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
(1521, 3285757, 44829497, '56716210', '0006005836001', '371383', '', '2661185', 'Cherie', 'Bell', '', '{\"DOB\": 25123, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"On Exchange\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Alliant\", \"HBA1C\": \"N\", \"Notes\": \"Fax Not Sent\", \"Aligned\": \"N\", \"PCP_NPI\": 1932159266, \"Pcp_Zip\": \"31210\", \"Program\": \"ACA\", \"PCP_Flag\": 0, \"Pcp_City\": \"MACON\", \"Pcp_Name\": \"Jennifer Duke\", \"PCP_Phone\": 4784710089, \"Pcp_State\": \"GA\", \"Member_City\": \"Macon\", \"Office_Name\": \"\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Macon\", \"Member_State\": \"GA\", \"Date_Of_Birth\": \"1968-10-12\", \"Mailing_State\": \"GA\", \"Member_Gender\": \"F\", \"Member_Region\": \"\", \"Pcp_Address_1\": \"540 CHARTER BLVD STE 100\", \"Screening_IHA\": \"No\", \"member_id_two\": 371383, \"Mailing_County\": \"BIBB\", \"Member_Country\": \"BIBB\", \"PCP_Fax_Number\": \"4784710708\", \"Plan_Term_Date\": \"2024-12-31\", \"Member_Address1\": \"478 Southern Oaks Dr\", \"Member_Address2\": \"\", \"Member_Zip_Code\": 31216, \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"478 Southern Oaks Dr\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": 31216, \"Member_Last_name\": \"Bell\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Cherie\", \"Plan_Effective_Date\": 45292, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_CurrentGender\": \"Female\", \"Member_Email_Address\": \"bell2ofus@yahoo.com\", \"Member_Suspect_Codes\": 21, \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Successful_Reaching_PCP\": \"No\", \"Member_Primary_Phone_Number\": 5132033233, \"Member_Identification_Number\": \"0006005836001\", \"Member_Alternate_Phone_Number\": \"\", \"Member_Secondary_Phone_Number\": \"\"}', 'client_009', '2024', '', '{\"hraStatus\":11,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'1', b'0', '{\"date\": \"11-26-2024 11:16:13\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}', '{\"date\": \"2024-11-26 11:16:13\", \"hrastatus\": \"\", \"reportstatus\": \"Completed\"}', '{\"LVM\": [], \"utc\": [], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2024-05-24T16:44\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-06-07T13:03\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-06-27T19:44\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-07-16T19:09\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [{\"date\": \"2024-11-14T13:05\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2024-11-19T14:13\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2024-11-20T11:44\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2024-11-26T11:16\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [{\"date\": \"2024-04-29T19:43\", \"text\": \"Scheduled\", \"method\": \"api\", \"status\": 0}, {\"date\": \"2024-07-02T18:29\", \"text\": \"Scheduled\", \"method\": \"api\", \"status\": 0}, {\"date\": \"2024-11-01T11:19\", \"text\": \"Scheduled\", \"method\": \"api\", \"status\": 0}], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [{\"date\": \"2024-05-24T15:16\", \"text\": \"Cancellation\", \"method\": \"api\", \"status\": 18}, {\"date\": \"2024-07-11T09:32\", \"text\": \"Cancellation\", \"method\": \"api\", \"status\": 18}], \"disconnected\": [], \"virtualNoShow\": [], \"callBackRequested\": [], \"callerDisconnected\": []}', '[{\"text\": \"Scheduled\", \"type\": \"ReportStatus\", \"status\": 0, \"hraStatus\": 1, \"hraStatus_date\": \"2024-04-29T19:43\", \"reportStatus_date\": \"2024-04-29T19:43\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": 3, \"hraStatus_date\": \"2024-05-24T15:16\", \"reportStatus_date\": \"2024-05-24T16:44\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-06-07T13:03\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-06-27T19:44\"}, {\"text\": \"Scheduled\", \"type\": \"ReportStatus\", \"status\": 0, \"hraStatus\": 1, \"hraStatus_date\": \"2024-07-02T18:29\", \"reportStatus_date\": \"2024-07-02T18:29\"}, {\"text\": \"Cancellation\", \"type\": \"ReportStatus\", \"status\": 18, \"hraStatus\": 3, \"hraStatus_date\": \"2024-07-11T09:32\", \"reportStatus_date\": \"2024-07-11T09:32\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-07-16T19:09\"}, {\"text\": \"Scheduled\", \"type\": \"ReportStatus\", \"status\": 0, \"hraStatus\": 1, \"hraStatus_date\": \"2024-11-01T11:19\", \"reportStatus_date\": \"2024-11-01T11:19\"}, {\"text\": \"Completed\", \"type\": \"HraStatus\", \"status\": 20, \"hraStatus\": 6, \"hraStatus_date\": \"2024-11-18T03:19\", \"reportStatus_date\": \"2024-11-14T13:05\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 10, \"hraStatus_date\": \"2024-11-20T11:44\", \"reportStatus_date\": \"2024-11-20T11:44\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 11, \"hraStatus_date\": \"2024-11-26T11:16\", \"reportStatus_date\": \"2024-11-26T11:16\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [{\"date\": \"2024-11-26T11:16\", \"username\": null}], \"scheduled\": [{\"date\": \"2024-04-29T19:43\", \"username\": null}, {\"date\": \"2024-04-29T19:43\", \"username\": null}, {\"date\": \"2024-07-02T18:29\", \"username\": null}, {\"date\": \"2024-07-02T18:29\", \"username\": null}, {\"date\": \"2024-11-01T11:19\", \"username\": null}, {\"date\": \"2024-11-01T11:19\", \"username\": null}], \"inProgress\": [{\"date\": \"2024-07-10T13:58\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-11-13T21:01\", \"username\": \"DAdams\"}], \"qaAssigned\": [{\"date\": \"2024-11-14T17:37\", \"username\": \"AWalsh\"}], \"readyForQa\": [{\"date\": \"2024-11-14T13:05\", \"username\": \"DAdams\"}, {\"date\": \"2024-11-14T13:05\", \"username\": \"DAdams\"}, {\"date\": \"2024-11-15T07:17\", \"username\": \"DAdams\"}, {\"date\": \"2024-11-18T03:19\", \"username\": \"DAdams\"}], \"inEligibile\": [], \"termExpired\": [], \"preScheduled\": [], \"coderAssigned\": [{\"date\": \"2024-11-20T11:44\", \"username\": \"JWren1\"}], \"readyForCoder\": [{\"date\": \"2024-11-19T14:13\", \"username\": \"BClark\"}], \"patientRefusal\": [], \"readyForUpload\": [{\"date\": \"2024-11-20T11:44\", \"username\": \"JWren1\"}], \"clinicianReviewQa\": [{\"date\": \"2024-11-14T22:54\", \"username\": \"BClark\"}, {\"date\": \"2024-11-15T07:16\", \"username\": \"DAdams\"}, {\"date\": \"2024-11-17T20:51\", \"username\": \"BClark\"}], \"assessmentCalcelled\": [], \"appointmentCancelled\": [{\"date\": \"2024-05-24T15:16\", \"username\": \"TOdleAdmin\"}, {\"date\": \"2024-07-11T09:32\", \"username\": \"TFerness2\"}], \"clinicianReviewCoder\": []}', '{\"history\": [{\"modified\": [{\"date\": \"01-16-2025\", \"time\": \"13:56:00\", \"value\": [{\"add\": \"478 Southern Oaks Dr\", \"age\": 56, \"ano\": \"\", \"cno\": \"\", \"dob\": \"1968-10-12\", \"eno\": \"5136936934\", \"lob\": \"On Exchange\", \"pno\": 5132033233, \"zip\": 31216, \"add2\": \"\", \"add3\": \"\", \"city\": \"Macon\", \"gend\": 1, \"insh\": \"0006005836001\", \"mzip\": 31216, \"name\": \"Cherie Bell\", \"plan\": \"Alliant\", \"pphy\": \"Jennifer Duke\", \"ppno\": 4784710089, \"race\": \"\", \"cliId\": \"\", \"email\": \"bell2ofus@yahoo.com\", \"ename\": \"Stephen Bell\", \"madd1\": \"478 Southern Oaks Dr\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Macon\", \"pcpid\": \"\", \"state\": \"GA\", \"mstate\": \"GA\", \"pcpadd\": \"540 CHARTER BLVD STE 100\", \"pcpnpi\": 1932159266, \"pcpzip\": \"31210\", \"region\": \"\", \"aligned\": \"N\", \"mstatus\": \"Married\", \"pcpFlag\": 0, \"pcpcity\": \"MACON\", \"pcpname\": \"\", \"program\": \"ACA\", \"evalDate\": \"2024-11-14 09:45 AM\", \"evalName\": \"Delise Adams, FNP\", \"pcpfaxno\": \"4784710708\", \"pcpstate\": \"GA\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"\", \"currentgend\": \"Female\", \"pphycomment\": \"\", \"primaryLanguage\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": [], \"indx\": [\"\", \"1\", \"\", \"\", \"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"\", \"1\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\"], \"comment\": [\"\", \"\"]}}, {\"a\": {\"sub\": {\"sub\": [], \"indx\": [[\"Jehovah Witness\"]], \"comment\": [[\"\"]]}, \"indx\": [\"1\", \"\"], \"comment\": [\"\", \"\"]}}, {\"a\": {\"indx\": [null, null, null, null, true], \"score\": [], \"comment\": [null, null, null, null, \"virtual\"]}}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"05-22-2024\", \"time\": \"12:25:21\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"01-16-2025 14:05:17\"}', '{\"utc\": [], \"noShow\": [], \"patientRefusal\": [], \"appointmentCancelled\": [{\"date\": \"2024-05-24T15:16\", \"type\": \"In Person\", \"subStaus\": \"\", \"username\": \"TOdleAdmin\", \"hraStatus\": 3, \"cancelText\": \"Provider has Covid\", \"cancelStatus\": 1}, {\"date\": \"2024-07-11T09:32\", \"type\": \"Virtual\", \"subStaus\": \"\", \"username\": \"TFerness2\", \"hraStatus\": 3, \"cancelText\": \"\", \"cancelStatus\": 0}]}', NULL, '{\"memberId\": \"0006005836001\", \"clinician\": \"Delise Adams\", \"qaAnalyst\": \"Brianne Clark\", \"queryData\": [{\"date\": \"Fri, 15 Nov 2024 03:54:00 GMT\", \"name\": \"Brianne \", \"role\": \"qa\", \"files\": [], \"query\": {\"feedback\": \"Hi Delise,\\n\\n1) Can you please select treatment for Onychomycosis under the assessment of diagnosis\\n2) Can you please select normal, abnormal, or add a comment for members gait under home safety\\n\\n\\nThank you!\", \"response\": \"\"}, \"mailId\": \"\"}, {\"date\": \"Fri, 15 Nov 2024 12:17:59 GMT\", \"name\": \"Delise \", \"role\": \"nurse\", \"files\": [], \"query\": {\"feedback\": \"\", \"response\": \"1. Added\\n2. Sorry, I\'m not seeing anything unmarked for gait on my end. \\n\\nThank you.\"}, \"mailId\": \"\"}, {\"date\": \"Mon, 18 Nov 2024 01:51:04 GMT\", \"name\": \"Brianne \", \"role\": \"qa\", \"files\": [], \"query\": {\"feedback\": \"Thank you for your updates!\\n1. Sorry I had meant under exam review for member\'s gait but its marked normal now, might have been a glitch.\\n2. Can you please correct the time of assessment. It is showing 9:45am and then finish at 10:43 pm\\n\\nThank you!\", \"response\": \"\"}, \"mailId\": \"\"}, {\"date\": \"Mon, 18 Nov 2024 08:19:15 GMT\", \"name\": \"Delise \", \"role\": \"nurse\", \"files\": [], \"query\": {\"feedback\": \"\", \"response\": \"1. No worries. \\n2. Corrected.\\nThank you. \"}, \"mailId\": \"\"}], \"memberName\": \"Cherie Bell\", \"codingAnalyst\": \"\", \"dateOfService\": \"11/14/2024 09:45 AM\", \"clinicianMailId\": \"deliseadams@sbcglobal.net\", \"qaAnalystMailId\": \"b.clark@focuscares.com\", \"codingAnalystMailId\": \"\"}', '{\"utc\": false, \"result\": 0, \"callLog\": [{\"date\": \"11/1/2024 @ 11:19 AM\", \"result\": 0, \"comment\": \"called for HRA-Virtual - Delise Adams-GA, NP : scheduled for 11/14 @ 9:45am\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Rocheline Lovaincy\", \"callbackDate\": \"\"}, {\"date\": \"7/16/2024 @ 07:09 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Jasmine Crawford\", \"callbackDate\": \"7/17/2024 @ 07:09 PM\"}, {\"date\": \"7/2/2024 @ 06:29 PM\", \"result\": 0, \"comment\": \"scheduled with faith virtually on 7/11 at 9am \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Jasmine Crawford\", \"callbackDate\": \"\"}, {\"date\": \"6/27/2024 @ 07:44 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Moira Roethle\", \"callbackDate\": \"7/4/2024 @ 07:44 PM\"}, {\"date\": \"6/7/2024 @ 01:03 PM\", \"result\": 3, \"comment\": \"LVM VIRTUAL VISIT WITH DEBORAH MV \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Mary Valdez\", \"callbackDate\": \"6/11/2024 @ 01:03 PM\"}, {\"date\": \"5/24/2024 @ 04:44 PM\", \"result\": 3, \"comment\": \"Called member to cancel appt with Laura Mclendon scheduled 5/26 @ 2:30 - LVM\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"5/28/2024 @ 04:44 PM\"}, {\"date\": \"4/29/2024 @ 07:43 PM\", \"result\": 0, \"comment\": \"Scheduled HRA w/ Laura Mclendon for 5/26/24 @ 2:30pm. Park on the street. -MR\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Moira Roethle\", \"callbackDate\": \"\"}], \"visitType\": {\"type\": \"visitType\", \"memberId\": \"0006005836001\", \"visitType\": \"Virtual\"}, \"clinicianId\": {\"type\": \"assignMember\", \"nurseId\": \"56716210\", \"memberId\": \"0006005836001\"}, \"appointmentDate\": {\"type\": \"scheduleDate\", \"nurseId\": -1, \"memberId\": \"0006005836001\", \"scheduleDate\": \"2024-11-14T09:45\"}}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"04-29-2024 19:43:00\", \"schedulerId\": \"2661185\", \"schedulerLeadId\": \"2661185\"}, {\"date\": \"05-24-2024 15:16:15\", \"schedulerId\": \"2661185\", \"schedulerLeadId\": \"2661185\"}, {\"date\": \"07-11-2024 09:32:21\", \"schedulerId\": \"2661185\", \"schedulerLeadId\": \"2661185\"}]}', '{\"date\": \"11-01-2024 11:19:50\", \"status\": 1, \"details\": \"scheduled directly\", \"disabled\": false, \"notification\": null}', '{\"attemptCount\": 7}', NULL, 0, NULL, '[{\"date\": \"2024-11-26 11:16:11\", \"status\": 0, \"message\": \"Fax sent failed\", \"fax_response\": \"{\\\"transaction_id\\\":\\\"c05e1f03-ac11-11ef-aec0-1dae207f5512\\\",\\\"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-11-14T09:45', '2024-12-31', '2024-11-14T09:45', NULL, NULL, NULL, NULL, '123456789', '21-04-2024 05:59:28', NULL, NULL, NULL, NULL, '{\"year\": \"2024\", \"client_id\": \"client_009\", \"member_id\": \"0006005836001\", \"reason_hra\": \"uploaded for HRA Assessment\", \"reason_summary\": \"uploaded for Summary Assessment\", \"assessment_name\": \"ACA_0006005836001_Bell, Cherie_11142024.pdf\", \"ftp_upload_date\": \"2024-11-26 11:16:10\", \"hra_uploadStatus\": \"success\", \"summary_uploadStats\": \"success\", \"summary_assessment_name\": \"PCP_Duke, Jennifer_0006005836001_11142024.pdf\"}', 'ACA_0006005836001_Bell, Cherie_11142024', NULL, 'PCP_Duke, Jennifer_0006005836001_11142024', NULL, '[{\"date\": \"2024-11-14T18:05:34.842Z\", \"signature\": \"data:image/png;base64,[encoded data, 23392 characters]\"}, {\"date\": \"2024-11-15T12:17:59.163Z\", \"signature\": \"data:image/png;base64,[encoded data, 23348 characters]\"}, {\"date\": \"2024-11-18T08:19:14.397Z\", \"signature\": \"data:image/png;base64,[encoded data, 23400 characters]\"}]', '2024-11-14T10:43', 'Member_Summary_0006005836001.pdf', '{\"year\": \"2024\", \"client_id\": \"client_009\", \"member_id\": \"0006005836001\", \"member_uploadStatus\": \"success\", \"reason_member_upload\": \"uploaded Member Summary Report\", \"member_assessment_name\": \"Member_Summary_0006005836001.pdf\", \"member_ftp_upload_date\": \"2024-11-26 11:16:12\"}', 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
(1522, NULL, NULL, NULL, '0006012174001', '358268', '', '2661185', 'Dana', 'Lavigne', '', '{\"DOB\": 28319, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"On Exchange\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Alliant\", \"HBA1C\": \"N\", \"Aligned\": \"N\", \"PCP_NPI\": 1912127861, \"Pcp_Zip\": \"\", \"Program\": \"ACA\", \"PCP_Flag\": \"1\", \"Pcp_City\": \"BLAIRSVILLE\", \"Pcp_Name\": \"CHRISTY COLLINS\", \"PCP_Phone\": 7068352222, \"Pcp_State\": \"GA\", \"Member_City\": \"Blairsville\", \"Office_Name\": \"\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Blairsville\", \"Member_State\": \"GA\", \"Date_Of_Birth\": \"1977-07-13\", \"Mailing_State\": \"GA\", \"Member_Gender\": \"F\", \"Member_Region\": \"\", \"Pcp_Address_1\": \"19 DOCTORS WAY\", \"Screening_IHA\": \"No\", \"member_id_two\": 358268, \"Mailing_County\": \"UNION\", \"Member_Country\": \"UNION\", \"PCP_Fax_Number\": \"\", \"Plan_Term_Date\": \"2024-12-31\", \"Member_Address1\": \"64 Akins Rd\", \"Member_Address2\": \"\", \"Member_Zip_Code\": 305120000, \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"64 Akins Rd\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": 30512, \"Member_Last_name\": \"Lavigne\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Dana\", \"Plan_Effective_Date\": 45292, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"danalavigne0@gmail.com\", \"Member_Suspect_Codes\": \"21, 82\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Phone_Number\": 7064008055, \"Member_Identification_Number\": \"0006012174001\", \"Member_Alternate_Phone_Number\": \"\"}', 'client_009', '2024', '', '{\"hraStatus\":18,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'1', b'1', '{\"date\": \"01-01-2025 23:33:05\", \"text\": \"Termed\", \"method\": \"auto\", \"status\": 22}', '{\"cron\": \"3\", \"date\": \"2025-01-01 23:33:05\", \"hrastatus\": 18, \"reportstatus\": \"\"}', '{\"LVM\": [], \"utc\": [{\"date\": \"2024-07-03T17:38\", \"text\": \"UTC\", \"method\": \"api\", \"status\": 19}], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2024-05-10T18:50\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-05-17T12:09\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-06-03T12:08\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-07-03T17:38\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [], \"disconnected\": [], \"virtualNoShow\": [], \"callBackRequested\": [], \"callerDisconnected\": []}', '[{\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": \"\", \"hraStatus_date\": \"\", \"reportStatus_date\": \"2024-05-10T18:50\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-05-17T12:09\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-06-03T12:08\"}, {\"text\": \"UTC\", \"type\": \"ReportStatus\", \"status\": 19, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-07-03T17:38\"}]', '{\"utc\": [{\"date\": \"2024-07-17T13:15\", \"username\": null}], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [], \"scheduled\": [], \"inProgress\": [], \"qaAssigned\": [], \"readyForQa\": [], \"inEligibile\": [], \"termExpired\": [], \"preScheduled\": [], \"coderAssigned\": [], \"readyForCoder\": [], \"patientRefusal\": [], \"readyForUpload\": [], \"clinicianReviewQa\": [], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": []}', '{\"history\": [{\"modified\": [{\"date\": \"04-21-2024\", \"time\": \"05:59:28\", \"value\": [{\"add\": \"64 Akins Rd\", \"age\": \"\", \"ano\": \"\", \"cno\": \"\", \"dob\": \"1977-07-13\", \"eno\": \"\", \"lob\": \"On Exchange\", \"pno\": 7064008055, \"zip\": 305120000, \"add2\": \"\", \"add3\": \"\", \"city\": \"Blairsville\", \"gend\": 1, \"insh\": \"0006012174001\", \"mzip\": 30512, \"name\": \"Dana Lavigne\", \"plan\": \"Alliant\", \"pphy\": \"CHRISTY COLLINS\", \"ppno\": 7068352222, \"cliId\": \"\", \"email\": \"danalavigne0@gmail.com\", \"ename\": \"\", \"madd1\": \"64 Akins Rd\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Blairsville\", \"pcpid\": \"\", \"state\": \"GA\", \"mstate\": \"GA\", \"pcpadd\": \"19 DOCTORS WAY\", \"pcpnpi\": 1912127861, \"pcpzip\": \"\", \"region\": \"\", \"aligned\": \"N\", \"mstatus\": \"\", \"pcpcity\": \"BLAIRSVILLE\", \"pcpname\": \"\", \"program\": \"ACA\", \"pcpfaxno\": \"\", \"pcpstate\": \"GA\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"\", \"currentgend\": \"\", \"pphycomment\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": {\"sub\": [], \"indx\": [[\"No Ethnicity\"]], \"comment\": [[\"\"]]}, \"indx\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"1\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": []}, {\"a\": []}, {\"a\": []}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"05-11-2024\", \"time\": \"03:24:43\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"05-11-2024 03:24:43\"}', NULL, NULL, NULL, '{\"utc\": false, \"result\": 3, \"callLog\": [{\"date\": \"10/28/2024 @ 04:32 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"\"}, {\"date\": \"8/31/2024 @ 01:30 PM\", \"result\": 3, \"comment\": \"Called to Schedule Virtual HRA with Faith no answer No VM Setup.\", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Melissa Trevino\", \"callbackDate\": \"\"}, {\"date\": \"8/17/2024 @ 01:00 PM\", \"result\": 3, \"comment\": \"Called to Schedule Virtual HRA with Faith no answer No VM Setup.\", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Melissa Trevino\", \"callbackDate\": \"\"}, {\"date\": \"8/1/2024 @ 02:00 PM\", \"result\": 3, \"comment\": \"Call attempt to schedule a virtual HRA - No VM setup. \", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"\"}, {\"date\": \"7/18/2024 @ 04:25 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Jasmine Crawford\", \"callbackDate\": \"\"}, {\"date\": \"7/3/2024 @ 05:38 PM\", \"result\": 3, \"comment\": \"Called to schedule HRA w/ Faith Enwefah\", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Tressa  Scott\", \"callbackDate\": \"\"}, {\"date\": \"6/3/2024 @ 12:08 PM\", \"result\": 3, \"comment\": \"NO VM SETUP - Unable to leave a message. Call attempt to schedule virtual HRA. \", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"6/4/2024 @ 12:08 PM\"}, {\"date\": \"6/3/2024 @ 12:08 PM\", \"result\": 3, \"comment\": \"5/20 -SR LVM\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"6/3/2024 @ 12:08 PM\"}, {\"date\": \"5/17/2024 @ 12:09 PM\", \"result\": 3, \"comment\": \"LEFT A VOICEMAIL-Call attempt to schedule a virtual HRA.\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"5/17/2024 @ 12:07 PM\"}, {\"date\": \"5/10/2024 @ 06:50 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Moira Roethle\", \"callbackDate\": \"5/11/2024 @ 06:50 PM\"}], \"clinicianId\": \"\", \"appointmentDate\": \"\"}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"05-10-2024 18:50:00\", \"schedulerId\": \"2661185\", \"schedulerLeadId\": \"2661185\"}]}', '{\"date\": \"07-03-2024 17:38:26\", \"status\": 3, \"details\": \"moved to utc\", \"disabled\": true, \"notification\": null}', '{\"attemptCount\": 10}', NULL, 1, NULL, NULL, NULL, NULL, '2024-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '21-04-2024 05:59:28', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(1523, NULL, NULL, NULL, '0006012316001', '239301', '', '21881792', 'Tammy', 'Fletter', '', '{\"DOB\": 25177, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"On Exchange\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Alliant\", \"HBA1C\": \"N\", \"Aligned\": \"N\", \"PCP_NPI\": 1780658674, \"Pcp_Zip\": \"\", \"Program\": \"ACA\", \"PCP_Flag\": \"1\", \"Pcp_City\": \"TOCCOA\", \"Pcp_Name\": \"STEPHEN LITTLE\", \"PCP_Phone\": 7702199300, \"Pcp_State\": \"GA\", \"Member_City\": \"Cleveland\", \"Office_Name\": \"\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Cleveland\", \"Member_State\": \"GA\", \"Date_Of_Birth\": \"1968-12-05\", \"Mailing_State\": \"GA\", \"Member_Gender\": \"F\", \"Member_Region\": \"\", \"Pcp_Address_1\": \"58 BIG A RD\", \"Screening_IHA\": \"No\", \"member_id_two\": 239301, \"Mailing_County\": \"WHITE\", \"Member_Country\": \"WHITE\", \"PCP_Fax_Number\": \"\", \"Plan_Term_Date\": \"2024-12-31\", \"Member_Address1\": \"45 Holcomb Dr\", \"Member_Address2\": \"\", \"Member_Zip_Code\": 305280000, \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"45 Holcomb Dr\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": 30528, \"Member_Last_name\": \"Fletter\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Tammy\", \"Member_Middle_name\": \"R\", \"Plan_Effective_Date\": 45292, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"Tfletter1@yahoo.com\", \"Member_Suspect_Codes\": \"110, 130, 131, 20, 21, 48, 57, 84\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Phone_Number\": 7068928408, \"Member_Identification_Number\": \"0006012316001\", \"Member_Alternate_Phone_Number\": \"\"}', 'client_009', '2024', '', '{\"hraStatus\":18,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'0', b'1', '{\"date\": \"01-01-2025 23:33:05\", \"text\": \"Termed\", \"method\": \"auto\", \"status\": 22}', '{\"cron\": \"3\", \"date\": \"2025-01-01 23:33:05\", \"hrastatus\": 18, \"reportstatus\": \"\"}', '{\"LVM\": [], \"utc\": [{\"date\": \"2024-10-29T13:45\", \"text\": \"UTC\", \"method\": \"api\", \"status\": 19}], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2024-07-09T12:28\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [], \"disconnected\": [], \"virtualNoShow\": [], \"callBackRequested\": [{\"date\": \"2024-06-06T15:54\", \"text\": \"Call Back\", \"method\": \"api\", \"status\": 9}, {\"date\": \"2024-07-11T13:36\", \"text\": \"Call Back\", \"method\": \"api\", \"status\": 9}, {\"date\": \"2024-07-15T17:53\", \"text\": \"Call Back\", \"method\": \"api\", \"status\": 9}, {\"date\": \"2024-07-29T17:00\", \"text\": \"Call Back\", \"method\": \"api\", \"status\": 9}, {\"date\": \"2024-10-29T13:45\", \"text\": \"Call Back\", \"method\": \"api\", \"status\": 9}], \"callerDisconnected\": []}', '[{\"text\": \"Call Back\", \"type\": \"ReportStatus\", \"status\": 9, \"hraStatus\": \"\", \"hraStatus_date\": \"\", \"reportStatus_date\": \"2024-06-06T15:54\"}, {\"text\": \"Call Back\", \"type\": \"ReportStatus\", \"status\": 9, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-07-15T17:53\"}, {\"text\": \"Call Back\", \"type\": \"ReportStatus\", \"status\": 9, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-07-29T17:00\"}, {\"text\": \"UTC\", \"type\": \"ReportStatus\", \"status\": 19, \"hraStatus\": 5, \"hraStatus_date\": \"2024-10-29T13:45\", \"reportStatus_date\": \"2024-10-29T13:45\"}]', '{\"utc\": [{\"date\": \"2024-10-29T13:45\", \"username\": null}], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [], \"scheduled\": [], \"inProgress\": [], \"qaAssigned\": [], \"readyForQa\": [], \"inEligibile\": [], \"termExpired\": [], \"preScheduled\": [], \"coderAssigned\": [], \"readyForCoder\": [], \"patientRefusal\": [], \"readyForUpload\": [], \"clinicianReviewQa\": [], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": []}', '{\"history\": [{\"modified\": [{\"date\": \"04-21-2024\", \"time\": \"05:59:29\", \"value\": [{\"add\": \"45 Holcomb Dr\", \"age\": \"\", \"ano\": \"\", \"cno\": \"\", \"dob\": \"1968-12-05\", \"eno\": \"\", \"lob\": \"On Exchange\", \"pno\": 7068928408, \"zip\": 305280000, \"add2\": \"\", \"add3\": \"\", \"city\": \"Cleveland\", \"gend\": 1, \"insh\": \"0006012316001\", \"mzip\": 30528, \"name\": \"Tammy R Fletter\", \"plan\": \"Alliant\", \"pphy\": \"STEPHEN LITTLE\", \"ppno\": 7702199300, \"cliId\": \"\", \"email\": \"Tfletter1@yahoo.com\", \"ename\": \"\", \"madd1\": \"45 Holcomb Dr\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Cleveland\", \"pcpid\": \"\", \"state\": \"GA\", \"mstate\": \"GA\", \"pcpadd\": \"58 BIG A RD\", \"pcpnpi\": 1780658674, \"pcpzip\": \"\", \"region\": \"\", \"aligned\": \"N\", \"mstatus\": \"\", \"pcpcity\": \"TOCCOA\", \"pcpname\": \"\", \"program\": \"ACA\", \"pcpfaxno\": \"\", \"pcpstate\": \"GA\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"\", \"currentgend\": \"\", \"pphycomment\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": {\"sub\": [], \"indx\": [[\"No Ethnicity\"]], \"comment\": [[\"\"]]}, \"indx\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"1\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": []}, {\"a\": []}, {\"a\": []}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"05-11-2024\", \"time\": \"03:24:43\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"05-11-2024 03:24:43\"}', '{\"utc\": [{\"date\": \"2024-10-29T13:45\", \"type\": null, \"subStaus\": \"\", \"username\": null, \"hraStatus\": 5, \"cancelText\": \"\", \"cancelStatus\": \"\"}], \"noShow\": [], \"patientRefusal\": [], \"appointmentCancelled\": []}', NULL, NULL, '{\"utc\": true, \"result\": 6, \"callLog\": [{\"date\": \"10/29/2024 @ 01:45 PM\", \"result\": 6, \"comment\": \"called for HRA-Virtual - Nykya Cox-GA, RN,NP : caller requested call back\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Rocheline Lovaincy\", \"callbackDate\": \"\"}, {\"date\": \"7/29/2024 @ 05:00 PM\", \"result\": 6, \"comment\": \"Called member to schedule HRA w/ NP Jansen Helm or w/NP Faith Enwefah member said she would call back busy with grandchildren.\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Tressa  Scott\", \"callbackDate\": \"8/3/2024 @ 05:00 PM\"}, {\"date\": \"7/15/2024 @ 05:53 PM\", \"result\": 6, \"comment\": \"07/15/2024 JC: called for HRA-Connie Middleton-Virtual: member req call back busy \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Julisa Copeland\", \"callbackDate\": \"7/29/2024 @ 05:53 PM\"}, {\"date\": \"7/11/2024 @ 01:36 PM\", \"result\": 6, \"comment\": \"CALL BACK REQUESTED - Member busy at the moment. Call back at a later date and time. \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Jasmine Crawford\", \"callbackDate\": \"7/12/2024 @ 01:36 PM\"}, {\"date\": \"7/9/2024 @ 12:28 PM\", \"result\": 3, \"comment\": \"Called to schedule HRA w/ FAITH ENWEFAH\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Tressa  Scott\", \"callbackDate\": \"7/17/2024 @ 12:28 PM\"}, {\"date\": \"6/6/2024 @ 03:54 PM\", \"result\": 6, \"comment\": \"Member requested a call back on another call. Attempted to schedule a virtual HRA.\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"6/7/2024 @ 03:54 PM\"}], \"clinicianId\": \"\", \"appointmentDate\": \"\"}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"06-06-2024 15:54:00\", \"schedulerId\": \"21881792\", \"schedulerLeadId\": \"21881792\"}]}', '{\"date\": \"04-22-2024 00:31:20\", \"status\": 0, \"details\": \"previous year member 10 months exceeded\", \"disabled\": false, \"notification\": null}', '{\"attemptCount\": 6}', NULL, 1, NULL, NULL, NULL, NULL, '2024-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '21-04-2024 05:59:29', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(1524, NULL, NULL, NULL, '0006012545001', '375480', '', '21881792', 'Takisha', 'Jones', '', '{\"DOB\": 26663, \"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\": \"Dalton\", \"Office_Name\": \"\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Tucker\", \"Member_State\": \"GA\", \"Date_Of_Birth\": \"1972-12-30\", \"Mailing_State\": \"GA\", \"Member_Gender\": \"F\", \"Member_Region\": \"\", \"Pcp_Address_1\": \"\", \"Screening_IHA\": \"No\", \"member_id_two\": 375480, \"Member_Country\": \"WHITFIELD\", \"PCP_Fax_Number\": \"\", \"Plan_Term_Date\": \"2024-12-31\", \"Member_Address1\": \"1819 Brady Dr Apt 4\", \"Member_Address2\": \"\", \"Member_Zip_Code\": 30720, \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"4325 1st Ave Unit 2613\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": 30085, \"Member_Last_name\": \"Jones\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Takisha\", \"Plan_Effective_Date\": 45292, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"mojones702@gmail.com\", \"Member_Suspect_Codes\": 120, \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Phone_Number\": 6787026313, \"Member_Identification_Number\": \"0006012545001\", \"Member_Alternate_Phone_Number\": \"\"}', 'client_009', '2024', '', '{\"hraStatus\":18,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'1', b'1', '{\"date\": \"01-01-2025 23:33:05\", \"text\": \"Termed\", \"method\": \"auto\", \"status\": 22}', '{\"cron\": \"3\", \"date\": \"2025-01-01 23:33:05\", \"hrastatus\": 18, \"reportstatus\": \"\"}', '{\"LVM\": [], \"utc\": [], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [], \"refusal\": [{\"date\": \"2024-04-24T09:45\", \"text\": \"Refusal\", \"method\": \"api\", \"status\": 13}], \"deceased\": [], \"lineBusy\": [], \"completed\": [], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [], \"disconnected\": [], \"virtualNoShow\": [], \"callBackRequested\": [], \"callerDisconnected\": []}', '[{\"text\": \"Refusal\", \"type\": \"ReportStatus\", \"status\": 13, \"hraStatus\": 4, \"hraStatus_date\": \"2024-04-24T09:45\", \"reportStatus_date\": \"2024-04-24T09:45\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [], \"scheduled\": [], \"inProgress\": [], \"qaAssigned\": [], \"readyForQa\": [], \"inEligibile\": [], \"termExpired\": [], \"preScheduled\": [], \"coderAssigned\": [], \"readyForCoder\": [], \"patientRefusal\": [{\"date\": \"2024-04-24T09:45\", \"username\": null}], \"readyForUpload\": [], \"clinicianReviewQa\": [], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": []}', '{\"history\": [{\"modified\": [{\"date\": \"04-21-2024\", \"time\": \"05:59:29\", \"value\": [{\"add\": \"1819 Brady Dr Apt 4\", \"age\": \"\", \"ano\": \"\", \"cno\": \"\", \"dob\": \"1972-12-30\", \"eno\": \"\", \"lob\": \"On Exchange\", \"pno\": 6787026313, \"zip\": 30720, \"add2\": \"\", \"add3\": \"\", \"city\": \"Dalton\", \"gend\": 1, \"insh\": \"0006012545001\", \"mzip\": 30085, \"name\": \"Takisha Jones\", \"plan\": \"Alliant\", \"pphy\": \" \", \"ppno\": \"\", \"cliId\": \"\", \"email\": \"mojones702@gmail.com\", \"ename\": \"\", \"madd1\": \"4325 1st Ave Unit 2613\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Tucker\", \"pcpid\": \"\", \"state\": \"GA\", \"mstate\": \"GA\", \"pcpadd\": \"\", \"pcpnpi\": \"\", \"pcpzip\": \"\", \"region\": \"\", \"aligned\": \"N\", \"mstatus\": \"\", \"pcpcity\": \"\", \"pcpname\": \"\", \"program\": \"ACA\", \"pcpfaxno\": \"\", \"pcpstate\": \"\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"\", \"currentgend\": \"\", \"pphycomment\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": {\"sub\": [], \"indx\": [[\"No Ethnicity\"]], \"comment\": [[\"\"]]}, \"indx\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"1\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": []}, {\"a\": []}, {\"a\": []}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"05-11-2024\", \"time\": \"03:24:44\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"05-11-2024 03:24:44\"}', '{\"utc\": [], \"noShow\": [], \"patientRefusal\": [{\"date\": \"2024-04-24T09:45\", \"type\": null, \"subStaus\": \"\", \"username\": null, \"hraStatus\": 4, \"cancelText\": \"\", \"cancelStatus\": \"\"}], \"appointmentCancelled\": []}', NULL, NULL, '{\"utc\": false, \"result\": 9, \"callLog\": [{\"date\": \"4/24/2024 @ 09:45 AM\", \"result\": 9, \"comment\": \"REFUSAL - MEMBER DECLINED TO SCHEDULE IHA IN 2024. \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"\"}], \"clinicianId\": \"\", \"appointmentDate\": \"\"}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"04-24-2024 09:45:00\", \"schedulerId\": \"21881792\", \"schedulerLeadId\": \"21881792\"}]}', '{\"date\": \"04-22-2024 00:31:20\", \"status\": 0, \"details\": \"previous year member 10 months exceeded\", \"disabled\": false, \"notification\": null}', '{\"attemptCount\": 1}', NULL, 1, NULL, NULL, NULL, NULL, '2024-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '21-04-2024 05:59:29', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(1525, NULL, NULL, NULL, '0006014585001', '202238', '', '21881792', 'Joey', 'Lents', '', '{\"DOB\": 23392, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"On Exchange\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Alliant\", \"HBA1C\": \"N\", \"Aligned\": \"N\", \"PCP_NPI\": 1285620831, \"Pcp_Zip\": \"\", \"Program\": \"ACA\", \"PCP_Flag\": \"1\", \"Pcp_City\": \"CHATSWORTH\", \"Pcp_Name\": \"JAMES BROWN\", \"PCP_Phone\": 7066950466, \"Pcp_State\": \"GA\", \"Member_City\": \"Chatsworth\", \"Office_Name\": \"\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Eton\", \"Member_State\": \"GA\", \"Date_Of_Birth\": \"1964-01-16\", \"Mailing_State\": \"GA\", \"Member_Gender\": \"M\", \"Member_Region\": \"\", \"Pcp_Address_1\": \"320 W MARKET ST\", \"Screening_IHA\": \"No\", \"member_id_two\": 202238, \"Member_Country\": \"Murray\", \"PCP_Fax_Number\": \"\", \"Plan_Term_Date\": \"2024-12-31\", \"Member_Address1\": \"7453 Hwy 225 North\", \"Member_Address2\": \"\", \"Member_Zip_Code\": 307050000, \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"PO Box 321\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": 30724, \"Member_Last_name\": \"Lents\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Joey\", \"Member_Middle_name\": \"M\", \"Plan_Effective_Date\": 45292, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"deborahlents@gmail.com\", \"Member_Suspect_Codes\": 56, \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Phone_Number\": 7065375186, \"Member_Identification_Number\": \"0006014585001\", \"Member_Alternate_Phone_Number\": \"\", \"Member_Secondary_Phone_Number\": 7062717396}', 'client_009', '2024', '', '{\"hraStatus\":18,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'1', b'1', '{\"date\": \"01-01-2025 23:33:05\", \"text\": \"Termed\", \"method\": \"auto\", \"status\": 22}', '{\"cron\": \"3\", \"date\": \"2025-01-01 23:33:05\", \"hrastatus\": 18, \"reportstatus\": \"\"}', '{\"LVM\": [], \"utc\": [{\"date\": \"2024-07-11T13:37\", \"text\": \"UTC\", \"method\": \"api\", \"status\": 19}], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2024-04-25T09:13\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-05-03T12:26\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-05-31T17:26\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-06-11T12:29\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-07-11T13:37\", \"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-25T09:13\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-05-03T12:26\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-05-31T17:26\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-06-11T12:29\"}, {\"text\": \"UTC\", \"type\": \"ReportStatus\", \"status\": 19, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-07-11T13:37\"}]', '{\"utc\": [{\"date\": \"2024-07-17T13:15\", \"username\": null}], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [], \"scheduled\": [], \"inProgress\": [], \"qaAssigned\": [], \"readyForQa\": [], \"inEligibile\": [], \"termExpired\": [], \"preScheduled\": [], \"coderAssigned\": [], \"readyForCoder\": [], \"patientRefusal\": [], \"readyForUpload\": [], \"clinicianReviewQa\": [], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": []}', '{\"history\": [{\"modified\": [{\"date\": \"04-21-2024\", \"time\": \"05:59:29\", \"value\": [{\"add\": \"7453 Hwy 225 North\", \"age\": \"\", \"ano\": \"\", \"cno\": 7062717396, \"dob\": \"1964-01-16\", \"eno\": \"\", \"lob\": \"On Exchange\", \"pno\": 7065375186, \"zip\": 307050000, \"add2\": \"\", \"add3\": \"\", \"city\": \"Chatsworth\", \"gend\": 0, \"insh\": \"0006014585001\", \"mzip\": 30724, \"name\": \"Joey M Lents\", \"plan\": \"Alliant\", \"pphy\": \"JAMES BROWN\", \"ppno\": 7066950466, \"cliId\": \"\", \"email\": \"deborahlents@gmail.com\", \"ename\": \"\", \"madd1\": \"PO Box 321\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Eton\", \"pcpid\": \"\", \"state\": \"GA\", \"mstate\": \"GA\", \"pcpadd\": \"320 W MARKET ST\", \"pcpnpi\": 1285620831, \"pcpzip\": \"\", \"region\": \"\", \"aligned\": \"N\", \"mstatus\": \"\", \"pcpcity\": \"CHATSWORTH\", \"pcpname\": \"\", \"program\": \"ACA\", \"pcpfaxno\": \"\", \"pcpstate\": \"GA\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"\", \"currentgend\": \"\", \"pphycomment\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": {\"sub\": [], \"indx\": [[\"No Ethnicity\"]], \"comment\": [[\"\"]]}, \"indx\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"1\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": []}, {\"a\": []}, {\"a\": []}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"05-11-2024\", \"time\": \"03:24:44\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"05-11-2024 03:24:44\"}', NULL, NULL, NULL, '{\"utc\": false, \"result\": 3, \"callLog\": [{\"date\": \"10/29/2024 @ 10:49 AM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"\"}, {\"date\": \"8/31/2024 @ 06:23 PM\", \"result\": 3, \"comment\": \"Called to Schedule Virtual HRA with Faith no answer LVM.\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Melissa Trevino\", \"callbackDate\": \"\"}, {\"date\": \"8/1/2024 @ 06:07 PM\", \"result\": 3, \"comment\": \"Call attempt to schedule a virtual HRA w/ Jansen Helm. - LVM\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"\"}, {\"date\": \"7/30/2024 @ 05:47 PM\", \"result\": 3, \"comment\": \"Called to schedule HRA w/ DELISE ADAMS lvm.\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Tressa  Scott\", \"callbackDate\": \"\"}, {\"date\": \"7/15/2024 @ 05:52 PM\", \"result\": 3, \"comment\": \"Call attempt to schedule a virtual HRA w/ Delise Adams. - LVM\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"\"}, {\"date\": \"7/11/2024 @ 01:37 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Jasmine Crawford\", \"callbackDate\": \"\"}, {\"date\": \"6/11/2024 @ 12:29 PM\", \"result\": 3, \"comment\": \"LEFT A VOICEMAIL- Call attempt to schedule a virtual HRA.\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"6/12/2024 @ 12:29 PM\"}, {\"date\": \"5/31/2024 @ 05:26 PM\", \"result\": 3, \"comment\": \"Called to schedule F2F HRA w/ Deborah York\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Lakisha Stewart\", \"callbackDate\": \"6/7/2024 @ 05:26 PM\"}, {\"date\": \"5/3/2024 @ 12:26 PM\", \"result\": 3, \"comment\": \"LEFT A VOICEMAIL - ATTEMPT TO SCHEDULE DEBBIE Y. 5/7 \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"5/8/2024 @ 12:26 PM\"}, {\"date\": \"4/25/2024 @ 09:13 AM\", \"result\": 3, \"comment\": \"LVM\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"4/26/2024 @ 09:13 AM\"}], \"clinicianId\": \"\", \"appointmentDate\": \"\"}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"04-25-2024 09:13:00\", \"schedulerId\": \"21881792\", \"schedulerLeadId\": \"21881792\"}]}', '{\"date\": \"07-11-2024 13:37:19\", \"status\": 3, \"details\": \"moved to utc\", \"disabled\": true, \"notification\": null}', '{\"attemptCount\": 10}', NULL, 1, NULL, NULL, NULL, NULL, '2024-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '21-04-2024 05:59:29', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(1526, NULL, NULL, NULL, '0006016848002', '395698', '', NULL, 'SHANTIBEN', 'PATEL', '', '{\"DOB\": 19941, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"On Exchange\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Alliant\", \"HBA1C\": \"N\", \"Aligned\": \"N\", \"PCP_NPI\": 1134215072, \"Pcp_Zip\": \"\", \"Program\": \"ACA\", \"PCP_Flag\": \"1\", \"Pcp_City\": \"WARNER ROBINS\", \"Pcp_Name\": \"GAYATRI KAMAT\", \"PCP_Phone\": 4783336977, \"Pcp_State\": \"GA\", \"Member_City\": \"Warner Robins\", \"Office_Name\": \"\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Warner Robins\", \"Member_State\": \"GA\", \"Date_Of_Birth\": \"1954-08-05\", \"Mailing_State\": \"GA\", \"Member_Gender\": \"F\", \"Member_Region\": \"\", \"Pcp_Address_1\": \"623 S HOUSTON LAKE RD STE 500\", \"Screening_IHA\": \"No\", \"member_id_two\": 395698, \"Mailing_County\": \"HOUSTON\", \"Member_Country\": \"HOUSTON\", \"PCP_Fax_Number\": \"\", \"Plan_Term_Date\": \"2024-12-31\", \"Member_Address1\": \"302 Estates Way\", \"Member_Address2\": \"\", \"Member_Zip_Code\": 31088, \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"302 Estates Way\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": 31088, \"Member_Last_name\": \"PATEL\", \"Medication_Review\": \"N\", \"Member_first_name\": \"SHANTIBEN\", \"Plan_Effective_Date\": 45292, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"\", \"Member_Suspect_Codes\": \"20, 21\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Phone_Number\": \"\", \"Member_Identification_Number\": \"0006016848002\", \"Member_Alternate_Phone_Number\": \"\"}', 'client_009', '2024', '', '{\"hraStatus\":18,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'0', b'0', '{\"date\": \"01-01-2025 23:33:05\", \"text\": \"Termed\", \"method\": \"auto\", \"status\": 22}', '{\"cron\": \"3\", \"date\": \"2025-01-01 23:33:05\", \"hrastatus\": 18, \"reportstatus\": \"\"}', NULL, NULL, NULL, '{\"history\": [{\"modified\": [{\"date\": \"04-21-2024\", \"time\": \"05:59:30\", \"value\": [{\"add\": \"302 Estates Way\", \"age\": \"\", \"ano\": \"\", \"cno\": \"\", \"dob\": \"1954-08-05\", \"eno\": \"\", \"lob\": \"On Exchange\", \"pno\": \"\", \"zip\": 31088, \"add2\": \"\", \"add3\": \"\", \"city\": \"Warner Robins\", \"gend\": 1, \"insh\": \"0006016848002\", \"mzip\": 31088, \"name\": \"SHANTIBEN PATEL\", \"plan\": \"Alliant\", \"pphy\": \"GAYATRI KAMAT\", \"ppno\": 4783336977, \"cliId\": \"\", \"email\": \"\", \"ename\": \"\", \"madd1\": \"302 Estates Way\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Warner Robins\", \"pcpid\": \"\", \"state\": \"GA\", \"mstate\": \"GA\", \"pcpadd\": \"623 S HOUSTON LAKE RD STE 500\", \"pcpnpi\": 1134215072, \"pcpzip\": \"\", \"region\": \"\", \"aligned\": \"N\", \"mstatus\": \"\", \"pcpcity\": \"WARNER ROBINS\", \"pcpname\": \"\", \"program\": \"ACA\", \"pcpfaxno\": \"\", \"pcpstate\": \"GA\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"\", \"currentgend\": \"\", \"pphycomment\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": {\"sub\": [], \"indx\": [[\"No Ethnicity\"]], \"comment\": [[\"\"]]}, \"indx\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"1\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": []}, {\"a\": []}, {\"a\": []}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"05-11-2024\", \"time\": \"03:24:44\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"05-11-2024 03:24:44\"}', NULL, NULL, NULL, NULL, NULL, '{\"date\": \"04-22-2024 00:31:20\", \"status\": 0, \"details\": \"previous year member 10 months exceeded\", \"disabled\": false, \"notification\": null}', NULL, NULL, 1, NULL, NULL, NULL, NULL, '2024-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '21-04-2024 05:59:30', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(1527, NULL, NULL, NULL, '0006019745002', '353802', '', NULL, 'Angelia', 'Chambliss', '', '{\"DOB\": 23958, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"On Exchange\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Alliant\", \"HBA1C\": \"N\", \"Aligned\": \"N\", \"PCP_NPI\": 1093891921, \"Pcp_Zip\": \"\", \"Program\": \"ACA\", \"PCP_Flag\": \"1\", \"Pcp_City\": \"BLAIRSVILLE\", \"Pcp_Name\": \"Thomas Gary\", \"PCP_Phone\": 7066321155, \"Pcp_State\": \"GA\", \"Member_City\": \"Toccoa\", \"Office_Name\": \"\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Toccoa\", \"Member_State\": \"GA\", \"Date_Of_Birth\": \"1965-08-04\", \"Mailing_State\": \"GA\", \"Member_Gender\": \"F\", \"Member_Region\": \"\", \"Pcp_Address_1\": \"346 DEEP SOUTH FARM RD STE A\", \"Screening_IHA\": \"No\", \"member_id_two\": 353802, \"Mailing_County\": \"Stephens\", \"Member_Country\": \"Stephens\", \"PCP_Fax_Number\": \"\", \"Plan_Term_Date\": \"2024-12-31\", \"Member_Address1\": \"70 Seminole Drive\", \"Member_Address2\": \"\", \"Member_Zip_Code\": 305770000, \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"70 Seminole Drive\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": 30577, \"Member_Last_name\": \"Chambliss\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Angelia\", \"Plan_Effective_Date\": 45292, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"\", \"Member_Suspect_Codes\": \"21, 88\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Phone_Number\": \"\", \"Member_Identification_Number\": \"0006019745002\", \"Member_Alternate_Phone_Number\": \"\"}', 'client_009', '2024', '', '{\"hraStatus\":18,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'0', b'0', '{\"date\": \"01-01-2025 23:33:06\", \"text\": \"Termed\", \"method\": \"auto\", \"status\": 22}', '{\"cron\": \"3\", \"date\": \"2025-01-01 23:33:06\", \"hrastatus\": 18, \"reportstatus\": \"\"}', NULL, NULL, NULL, '{\"history\": [{\"modified\": [{\"date\": \"04-21-2024\", \"time\": \"05:59:30\", \"value\": [{\"add\": \"70 Seminole Drive\", \"age\": \"\", \"ano\": \"\", \"cno\": \"\", \"dob\": \"1965-08-04\", \"eno\": \"\", \"lob\": \"On Exchange\", \"pno\": \"\", \"zip\": 305770000, \"add2\": \"\", \"add3\": \"\", \"city\": \"Toccoa\", \"gend\": 1, \"insh\": \"0006019745002\", \"mzip\": 30577, \"name\": \"Angelia Chambliss\", \"plan\": \"Alliant\", \"pphy\": \"Thomas Gary\", \"ppno\": 7066321155, \"cliId\": \"\", \"email\": \"\", \"ename\": \"\", \"madd1\": \"70 Seminole Drive\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Toccoa\", \"pcpid\": \"\", \"state\": \"GA\", \"mstate\": \"GA\", \"pcpadd\": \"346 DEEP SOUTH FARM RD STE A\", \"pcpnpi\": 1093891921, \"pcpzip\": \"\", \"region\": \"\", \"aligned\": \"N\", \"mstatus\": \"\", \"pcpcity\": \"BLAIRSVILLE\", \"pcpname\": \"\", \"program\": \"ACA\", \"pcpfaxno\": \"\", \"pcpstate\": \"GA\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"\", \"currentgend\": \"\", \"pphycomment\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": {\"sub\": [], \"indx\": [[\"No Ethnicity\"]], \"comment\": [[\"\"]]}, \"indx\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"1\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": []}, {\"a\": []}, {\"a\": []}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"05-11-2024\", \"time\": \"03:24:44\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"05-11-2024 03:24:44\"}', NULL, NULL, NULL, NULL, NULL, '{\"date\": \"04-22-2024 00:31:20\", \"status\": 0, \"details\": \"previous year member 10 months exceeded\", \"disabled\": false, \"notification\": null}', NULL, NULL, 1, NULL, NULL, NULL, NULL, '2024-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '21-04-2024 05:59:30', 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
(1528, 57818338, 44829497, '62685179', '0006021840001', '385844', '', '26056802', 'Stephen', 'Emerson', '', '{\"DOB\": 24511, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"On Exchange\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Alliant\", \"HBA1C\": \"N\", \"Notes\": \"Fax Not Sent\", \"Aligned\": \"N\", \"PCP_NPI\": 1225498694, \"Pcp_Zip\": \"30501\", \"Program\": \"ACA\", \"PCP_Flag\": 0, \"Pcp_City\": \"GAINESVILLE\", \"Pcp_Name\": \"URVESH PATEL\", \"PCP_Phone\": \"7702199000\", \"Pcp_State\": \"GA\", \"Member_City\": \"Alto\", \"Office_Name\": \"\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Alto\", \"Member_State\": \"GA\", \"Date_Of_Birth\": \"1967-02-08\", \"Mailing_State\": \"GA\", \"Member_Gender\": \"M\", \"Member_Region\": \"\", \"Pcp_Address_1\": \"743 SPRING ST NE\", \"Screening_IHA\": \"No\", \"member_id_two\": 385844, \"Mailing_County\": \"HALL\", \"Member_Country\": \"HALL\", \"PCP_Fax_Number\": \"7702196021\", \"Plan_Term_Date\": \"2024-12-31\", \"Member_Address1\": \"543 Highland Pointe Dr\", \"Member_Address2\": \"\", \"Member_Zip_Code\": 30510, \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"543 Highland Pointe Dr\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": 30510, \"Member_Last_name\": \"Emerson\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Stephen\", \"Plan_Effective_Date\": 45292, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_CurrentGender\": \"Male\", \"Member_Email_Address\": \"semerson2867@gmail.com\", \"Member_Suspect_Codes\": \"20, 21, 217\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Successful_Reaching_PCP\": \"No\", \"Member_Primary_Phone_Number\": 7708629834, \"Member_Identification_Number\": \"0006021840001\", \"Member_Alternate_Phone_Number\": \"\", \"Member_Secondary_Phone_Number\": \"\"}', 'client_009', '2024', '', '{\"hraStatus\":11,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 2, b'0', b'1', '{\"date\": \"11-12-2024 21:18:54\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}', '{\"date\": \"2024-11-12 21:18:54\", \"hrastatus\": \"\", \"reportstatus\": \"Completed\"}', '{\"LVM\": [], \"utc\": [], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [{\"date\": \"2024-11-04T06:59\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2024-11-06T13:33\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2024-11-07T12:18\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2024-11-12T21:18\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [{\"date\": \"2024-10-28T13:09\", \"text\": \"Scheduled\", \"method\": \"api\", \"status\": 0}], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [], \"disconnected\": [], \"virtualNoShow\": [], \"callBackRequested\": [{\"date\": \"2024-06-05T12:25\", \"text\": \"Call Back\", \"method\": \"api\", \"status\": 9}, {\"date\": \"2024-07-10T13:48\", \"text\": \"Call Back\", \"method\": \"api\", \"status\": 9}, {\"date\": \"2024-07-29T17:09\", \"text\": \"Call Back\", \"method\": \"api\", \"status\": 9}], \"callerDisconnected\": []}', '[{\"text\": \"Call Back\", \"type\": \"ReportStatus\", \"status\": 9, \"hraStatus\": \"\", \"hraStatus_date\": \"\", \"reportStatus_date\": \"2024-06-05T12:25\"}, {\"text\": \"Call Back\", \"type\": \"ReportStatus\", \"status\": 9, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-07-10T13:48\"}, {\"text\": \"Call Back\", \"type\": \"ReportStatus\", \"status\": 9, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-07-29T17:09\"}, {\"text\": \"Scheduled\", \"type\": \"ReportStatus\", \"status\": 0, \"hraStatus\": 1, \"hraStatus_date\": \"2024-10-28T13:09\", \"reportStatus_date\": \"2024-10-28T13:09\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 6, \"hraStatus_date\": \"2024-11-04T06:59\", \"reportStatus_date\": \"2024-11-04T06:59\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 10, \"hraStatus_date\": \"2024-11-07T12:18\", \"reportStatus_date\": \"2024-11-07T12:18\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 11, \"hraStatus_date\": \"2024-11-12T21:18\", \"reportStatus_date\": \"2024-11-12T21:18\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [{\"date\": \"2024-11-12T21:18\", \"username\": null}], \"scheduled\": [{\"date\": \"2024-10-28T13:09\", \"username\": null}, {\"date\": \"2024-10-28T13:09\", \"username\": null}], \"inProgress\": [{\"date\": \"2024-11-01T07:42\", \"username\": \"FEnwefah\"}], \"qaAssigned\": [{\"date\": \"2024-11-04T11:04\", \"username\": \"AWalsh\"}], \"readyForQa\": [{\"date\": \"2024-11-04T06:59\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-11-04T06:59\", \"username\": \"FEnwefah\"}], \"inEligibile\": [], \"termExpired\": [], \"preScheduled\": [], \"coderAssigned\": [{\"date\": \"2024-11-07T12:18\", \"username\": \"JWren1\"}], \"readyForCoder\": [{\"date\": \"2024-11-06T13:33\", \"username\": \"JSilverio\"}], \"patientRefusal\": [], \"readyForUpload\": [{\"date\": \"2024-11-07T12:18\", \"username\": \"JWren1\"}], \"clinicianReviewQa\": [], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": []}', '{\"history\": [{\"modified\": [{\"date\": \"01-13-2025\", \"time\": \"14:35:19\", \"value\": [{\"add\": \"543 Highland Pointe Dr\", \"age\": 57, \"ano\": \"\", \"cno\": \"\", \"dob\": \"1967-02-08\", \"eno\": \"\", \"lob\": \"On Exchange\", \"pno\": 7708629834, \"zip\": 30510, \"add2\": \"\", \"add3\": \"\", \"city\": \"Alto\", \"gend\": 0, \"insh\": \"0006021840001\", \"mzip\": 30510, \"name\": \"Stephen Emerson\", \"plan\": \"Alliant\", \"pphy\": \"URVESH PATEL\", \"ppno\": \"7702199000\", \"cliId\": \"\", \"email\": \"semerson2867@gmail.com\", \"ename\": \"Kay Andrews\", \"madd1\": \"543 Highland Pointe Dr\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Alto\", \"pcpid\": \"\", \"state\": \"GA\", \"mstate\": \"GA\", \"pcpadd\": \"743 SPRING ST NE\", \"pcpnpi\": 1225498694, \"pcpzip\": \"30501\", \"region\": \"\", \"aligned\": \"N\", \"mstatus\": \"Single\", \"pcpFlag\": 0, \"pcpcity\": \"GAINESVILLE\", \"pcpname\": \"\", \"program\": \"ACA\", \"pcpfaxno\": \"7702196021\", \"pcpstate\": \"GA\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"\", \"currentgend\": \"Male\", \"pphycomment\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"\", \"1\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\"], \"comment\": [\"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"\", \"1\"], \"comment\": [\"\", \"\"]}}, {\"a\": {\"indx\": [], \"score\": [], \"comment\": []}}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"11-01-2024\", \"time\": \"07:42:55\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"01-13-2025 14:35:49\"}', NULL, NULL, NULL, '{\"utc\": false, \"result\": 0, \"callLog\": [{\"date\": \"10/28/2024 @ 01:09 PM\", \"result\": 0, \"comment\": \"called for HRA-Virtual - Faith Enwefah-GA, RN,NP : scheduled for 11/01 @10am\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Rocheline Lovaincy\", \"callbackDate\": \"\"}, {\"date\": \"7/29/2024 @ 05:09 PM\", \"result\": 6, \"comment\": \"Called member to schedule HRA w/ NP Jansen Helm or w/NP Faith Enwefah member works 16 a day during the week but his weekends are open. I searched for weekend availability and at this time Np\'s are booked up. informed member we would reach out once schedules open up for weekend slots.\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Tressa  Scott\", \"callbackDate\": \"8/10/2024 @ 05:09 PM\"}, {\"date\": \"7/10/2024 @ 01:48 PM\", \"result\": 6, \"comment\": \"with work schedule unable to do HRA\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Jasmine Crawford\", \"callbackDate\": \"7/11/2024 @ 01:48 PM\"}, {\"date\": \"6/5/2024 @ 12:25 PM\", \"result\": 6, \"comment\": \"Called to schedule F2F HRA w/ Delise Adams - member is open to scheduling HRA but either on the weekend or after 5pm as he currently works outside of that\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Lakisha Stewart\", \"callbackDate\": \"6/26/2024 @ 12:25 PM\"}], \"visitType\": {\"type\": \"visitType\", \"memberId\": \"0006021840001\", \"visitType\": \"Virtual\"}, \"clinicianId\": {\"type\": \"assignMember\", \"nurseId\": \"62685179\", \"memberId\": \"0006021840001\"}, \"appointmentDate\": {\"type\": \"scheduleDate\", \"nurseId\": -1, \"memberId\": \"0006021840001\", \"scheduleDate\": \"2024-11-1T10:00\"}}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"06-05-2024 12:25:00\", \"schedulerId\": \"26056802\", \"schedulerLeadId\": \"26056802\"}]}', '{\"date\": \"10-28-2024 13:09:09\", \"status\": 1, \"details\": \"scheduled directly\", \"disabled\": false, \"notification\": null}', '{\"attemptCount\": 4}', NULL, 0, NULL, '[{\"date\": \"2024-11-12 21:18:52\", \"status\": 0, \"message\": \"Fax sent failed\", \"fax_response\": \"{\\\"transaction_id\\\":\\\"a07b52b8-a165-11ef-b885-affe8067c713\\\",\\\"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-11-1T10:00', '2024-12-31', '2024-11-02T10:00', NULL, NULL, NULL, NULL, '123456789', '21-04-2024 05:59:30', NULL, NULL, NULL, NULL, '{\"year\": \"2024\", \"client_id\": \"client_009\", \"member_id\": \"0006021840001\", \"reason_hra\": \"uploaded for HRA Assessment\", \"reason_summary\": \"uploaded for Summary Assessment\", \"assessment_name\": \"ACA_0006021840001_Emerson, Stephen_11012024.pdf\", \"ftp_upload_date\": \"2024-11-12 21:18:52\", \"hra_uploadStatus\": \"success\", \"summary_uploadStats\": \"success\", \"summary_assessment_name\": \"PCP_PATEL, URVESH_0006021840001_11012024.pdf\"}', 'ACA_0006021840001_Emerson, Stephen_11012024', NULL, 'PCP_PATEL, URVESH_0006021840001_11012024', NULL, '[{\"date\": \"2024-11-04T11:59:24.037Z\", \"signature\": \"data:image/png;base64,[encoded data, 23400 characters]\"}]', '2024-11-02T11:00', 'Member_Summary_0006021840001.pdf', '{\"year\": \"2024\", \"client_id\": \"client_009\", \"member_id\": \"0006021840001\", \"member_uploadStatus\": \"success\", \"reason_member_upload\": \"uploaded Member Summary Report\", \"member_assessment_name\": \"Member_Summary_0006021840001.pdf\", \"member_ftp_upload_date\": \"2024-11-12 21:18:53\"}', NULL, NULL, NULL, NULL),
(1529, NULL, NULL, NULL, '0006025435001', '383764', '', '2661185', 'Teresa', 'Denton', '', '{\"DOB\": 24990, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"On Exchange\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Alliant\", \"HBA1C\": \"N\", \"Aligned\": \"N\", \"PCP_NPI\": 1356440853, \"Pcp_Zip\": \"\", \"Program\": \"ACA\", \"PCP_Flag\": \"1\", \"Pcp_City\": \"HIAWASSEE\", \"Pcp_Name\": \"Robert Stahlkuppe\", \"PCP_Phone\": 7068962289, \"Pcp_State\": \"GA\", \"Member_City\": \"Young Harris\", \"Office_Name\": \"\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Young Harris\", \"Member_State\": \"GA\", \"Date_Of_Birth\": \"1968-06-01\", \"Mailing_State\": \"GA\", \"Member_Gender\": \"F\", \"Member_Region\": \"\", \"Pcp_Address_1\": \"56 HOSPITAL ST\", \"Screening_IHA\": \"No\", \"member_id_two\": 383764, \"Mailing_County\": \"TOWNS\", \"Member_Country\": \"TOWNS\", \"PCP_Fax_Number\": \"\", \"Plan_Term_Date\": \"2024-12-31\", \"Member_Address1\": \"2602 Brown Rd\", \"Member_Address2\": \"\", \"Member_Zip_Code\": 30582, \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"2602 Brown Rd\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": 30582, \"Member_Last_name\": \"Denton\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Teresa\", \"Member_Middle_name\": \"L\", \"Plan_Effective_Date\": 45292, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"teresa.denton68@gmail.com\", \"Member_Suspect_Codes\": \"160, 161.1, 161.2, 162, 48\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Phone_Number\": 7069942194, \"Member_Identification_Number\": \"0006025435001\", \"Member_Alternate_Phone_Number\": \"\"}', 'client_009', '2024', '', '{\"hraStatus\":18,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'1', b'1', '{\"date\": \"01-01-2025 23:33:06\", \"text\": \"Termed\", \"method\": \"auto\", \"status\": 22}', '{\"cron\": \"3\", \"date\": \"2025-01-01 23:33:06\", \"hrastatus\": 18, \"reportstatus\": \"\"}', '{\"LVM\": [], \"utc\": [{\"date\": \"2024-07-03T17:39\", \"text\": \"UTC\", \"method\": \"api\", \"status\": 19}, {\"date\": \"2024-08-19T13:24\", \"text\": \"UTC\", \"method\": \"api\", \"status\": 19}], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2024-07-03T17:39\", \"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-10T18:55\", \"text\": \"Disconnected\", \"method\": \"api\", \"status\": 14}, {\"date\": \"2024-05-13T13:35\", \"text\": \"Disconnected\", \"method\": \"api\", \"status\": 14}, {\"date\": \"2024-05-17T12:09\", \"text\": \"Disconnected\", \"method\": \"api\", \"status\": 14}, {\"date\": \"2024-06-27T19:44\", \"text\": \"Disconnected\", \"method\": \"api\", \"status\": 14}], \"virtualNoShow\": [], \"callBackRequested\": [], \"callerDisconnected\": []}', '[{\"text\": \"Disconnected\", \"type\": \"ReportStatus\", \"status\": 14, \"hraStatus\": \"\", \"hraStatus_date\": \"\", \"reportStatus_date\": \"2024-05-13T13:35\"}, {\"text\": \"Disconnected\", \"type\": \"ReportStatus\", \"status\": 14, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-05-17T12:09\"}, {\"text\": \"Disconnected\", \"type\": \"ReportStatus\", \"status\": 14, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-06-27T19:44\"}, {\"text\": \"UTC\", \"type\": \"ReportStatus\", \"status\": 19, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-07-03T17:39\"}, {\"text\": \"UTC\", \"type\": \"ReportStatus\", \"status\": 19, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-08-19T13:24\"}]', '{\"utc\": [{\"date\": \"2024-07-17T13:15\", \"username\": null}], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [], \"scheduled\": [], \"inProgress\": [], \"qaAssigned\": [], \"readyForQa\": [], \"inEligibile\": [], \"termExpired\": [], \"preScheduled\": [], \"coderAssigned\": [], \"readyForCoder\": [], \"patientRefusal\": [], \"readyForUpload\": [], \"clinicianReviewQa\": [], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": []}', '{\"history\": [{\"modified\": [{\"date\": \"04-21-2024\", \"time\": \"05:59:30\", \"value\": [{\"add\": \"2602 Brown Rd\", \"age\": \"\", \"ano\": \"\", \"cno\": \"\", \"dob\": \"1968-06-01\", \"eno\": \"\", \"lob\": \"On Exchange\", \"pno\": 7069942194, \"zip\": 30582, \"add2\": \"\", \"add3\": \"\", \"city\": \"Young Harris\", \"gend\": 1, \"insh\": \"0006025435001\", \"mzip\": 30582, \"name\": \"Teresa L Denton\", \"plan\": \"Alliant\", \"pphy\": \"Robert Stahlkuppe\", \"ppno\": 7068962289, \"cliId\": \"\", \"email\": \"teresa.denton68@gmail.com\", \"ename\": \"\", \"madd1\": \"2602 Brown Rd\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Young Harris\", \"pcpid\": \"\", \"state\": \"GA\", \"mstate\": \"GA\", \"pcpadd\": \"56 HOSPITAL ST\", \"pcpnpi\": 1356440853, \"pcpzip\": \"\", \"region\": \"\", \"aligned\": \"N\", \"mstatus\": \"\", \"pcpcity\": \"HIAWASSEE\", \"pcpname\": \"\", \"program\": \"ACA\", \"pcpfaxno\": \"\", \"pcpstate\": \"GA\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"\", \"currentgend\": \"\", \"pphycomment\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": {\"sub\": [], \"indx\": [[\"No Ethnicity\"]], \"comment\": [[\"\"]]}, \"indx\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"1\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": []}, {\"a\": []}, {\"a\": []}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"05-11-2024\", \"time\": \"03:24:44\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"05-11-2024 03:24:44\"}', NULL, NULL, NULL, '{\"utc\": false, \"result\": 7, \"callLog\": [{\"date\": \"11/6/2024 @ 06:58 PM\", \"result\": 7, \"comment\": \"\", \"inBound\": false, \"noAnswer\": \"-1\", \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"\"}, {\"date\": \"8/19/2024 @ 01:24 PM\", \"result\": 3, \"comment\": \"Called to Schedule Virtual HRA with Debbie no answer LVM.\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Melissa Trevino\", \"callbackDate\": \"\"}, {\"date\": \"8/1/2024 @ 01:58 PM\", \"result\": 10, \"comment\": \"Called to schedule HRA w/ DELISE ADAMS LINE DISCONNECTED.\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Tressa  Scott\", \"callbackDate\": \"\"}, {\"date\": \"7/18/2024 @ 04:26 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Jasmine Crawford\", \"callbackDate\": \"\"}, {\"date\": \"7/3/2024 @ 05:39 PM\", \"result\": 3, \"comment\": \"Called to schedule HRA w/ Faith Enwefah\", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Tressa  Scott\", \"callbackDate\": \"\"}, {\"date\": \"6/27/2024 @ 07:44 PM\", \"result\": 10, \"comment\": \"\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Moira Roethle\", \"callbackDate\": \"7/4/2024 @ 07:44 PM\"}, {\"date\": \"5/17/2024 @ 12:09 PM\", \"result\": 10, \"comment\": \"Called to schedule Virtual HRA w/ Faith Enwefah - Disconnected\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Lakisha Stewart\", \"callbackDate\": \"5/24/2024 @ 12:09 PM\"}, {\"date\": \"5/13/2024 @ 01:35 PM\", \"result\": 10, \"comment\": \"\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Grace Medrano\", \"callbackDate\": \"5/18/2024 @ 01:35 PM\"}, {\"date\": \"5/10/2024 @ 06:55 PM\", \"result\": 10, \"comment\": \"\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Moira Roethle\", \"callbackDate\": \"5/11/2024 @ 06:55 PM\"}], \"clinicianId\": \"\", \"appointmentDate\": \"\"}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"05-10-2024 18:55:00\", \"schedulerId\": \"2661185\", \"schedulerLeadId\": \"2661185\"}]}', '{\"date\": \"08-19-2024 13:24:05\", \"status\": 3, \"details\": \"moved to utc\", \"disabled\": true, \"notification\": null}', '{\"attemptCount\": 9}', NULL, 1, NULL, NULL, NULL, NULL, '2024-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '21-04-2024 05:59:30', 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
(1530, NULL, NULL, NULL, '0006026875001', '383172', '', '2661185', 'IVORY', 'GARZA', '', '{\"DOB\": 36633, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"On Exchange\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Alliant\", \"HBA1C\": \"N\", \"Aligned\": \"N\", \"PCP_NPI\": 1801987292, \"Pcp_Zip\": \"\", \"Program\": \"ACA\", \"PCP_Flag\": \"1\", \"Pcp_City\": \"MOULTRIE\", \"Pcp_Name\": \"Kirby Smith\", \"PCP_Phone\": 2298919131, \"Pcp_State\": \"GA\", \"Member_City\": \"Valdosta\", \"Office_Name\": \"\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Valdosta\", \"Member_State\": \"GA\", \"Date_Of_Birth\": \"2000-04-17\", \"Mailing_State\": \"GA\", \"Member_Gender\": \"F\", \"Member_Region\": \"\", \"Pcp_Address_1\": \"3131 S MAIN ST\", \"Screening_IHA\": \"No\", \"member_id_two\": 383172, \"Mailing_County\": \"LOWNDES\", \"Member_Country\": \"LOWNDES\", \"PCP_Fax_Number\": \"\", \"Plan_Term_Date\": \"2024-12-31\", \"Member_Address1\": \"3058 Schroer Dr\", \"Member_Address2\": \"\", \"Member_Zip_Code\": 31602, \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"3058 Schroer Dr\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": 31602, \"Member_Ethnicity\": \"Mexican, Mexican American, or Chicano/a\", \"Member_Last_name\": \"GARZA\", \"Medication_Review\": \"N\", \"Member_first_name\": \"IVORY\", \"Member_Middle_name\": \"ANNA MARIE\", \"Plan_Effective_Date\": 45292, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"ivorylina8@gmail.com\", \"Member_Suspect_Codes\": 120, \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Phone_Number\": 2299214638, \"Member_Identification_Number\": \"0006026875001\", \"Member_Alternate_Phone_Number\": \"\"}', 'client_009', '2024', '', '{\"hraStatus\":18,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'1', b'1', '{\"date\": \"01-01-2025 23:33:06\", \"text\": \"Termed\", \"method\": \"auto\", \"status\": 22}', '{\"cron\": \"3\", \"date\": \"2025-01-01 23:33:06\", \"hrastatus\": 18, \"reportstatus\": \"\"}', '{\"LVM\": [], \"utc\": [{\"date\": \"2024-07-02T18:23\", \"text\": \"UTC\", \"method\": \"api\", \"status\": 19}], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2024-05-10T18:58\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-05-17T12:09\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-05-20T16:38\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-06-27T19:45\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-07-02T18:23\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [], \"disconnected\": [], \"virtualNoShow\": [], \"callBackRequested\": [], \"callerDisconnected\": []}', '[{\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": \"\", \"hraStatus_date\": \"\", \"reportStatus_date\": \"2024-05-10T18:58\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-05-20T16:38\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-06-27T19:45\"}, {\"text\": \"UTC\", \"type\": \"ReportStatus\", \"status\": 19, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-07-02T18:23\"}]', NULL, '{\"history\": [{\"modified\": [{\"date\": \"04-21-2024\", \"time\": \"05:59:31\", \"value\": [{\"add\": \"3058 Schroer Dr\", \"age\": \"\", \"ano\": \"\", \"cno\": \"\", \"dob\": \"2000-04-17\", \"eno\": \"\", \"lob\": \"On Exchange\", \"pno\": 2299214638, \"zip\": 31602, \"add2\": \"\", \"add3\": \"\", \"city\": \"Valdosta\", \"gend\": 1, \"insh\": \"0006026875001\", \"mzip\": 31602, \"name\": \"IVORY ANNA MARIE GARZA\", \"plan\": \"Alliant\", \"pphy\": \"Kirby Smith\", \"ppno\": 2298919131, \"cliId\": \"\", \"email\": \"ivorylina8@gmail.com\", \"ename\": \"\", \"madd1\": \"3058 Schroer Dr\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Valdosta\", \"pcpid\": \"\", \"state\": \"GA\", \"mstate\": \"GA\", \"pcpadd\": \"3131 S MAIN ST\", \"pcpnpi\": 1801987292, \"pcpzip\": \"\", \"region\": \"\", \"aligned\": \"N\", \"mstatus\": \"\", \"pcpcity\": \"MOULTRIE\", \"pcpname\": \"\", \"program\": \"ACA\", \"pcpfaxno\": \"\", \"pcpstate\": \"GA\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"\", \"currentgend\": \"\", \"pphycomment\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": {\"sub\": [], \"indx\": [[\"No Ethnicity\"]], \"comment\": [[\"\"]]}, \"indx\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"1\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": []}, {\"a\": []}, {\"a\": []}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"05-11-2024\", \"time\": \"03:24:44\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"05-11-2024 03:24:44\"}', NULL, NULL, NULL, '{\"utc\": false, \"result\": 1, \"callLog\": [{\"date\": \"11/6/2024 @ 05:36 PM\", \"result\": 1, \"comment\": \"\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Rebecca Mangold\", \"callbackDate\": \"\"}, {\"date\": \"7/16/2024 @ 07:10 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Jasmine Crawford\", \"callbackDate\": \"\"}, {\"date\": \"7/2/2024 @ 06:23 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Tressa  Scott\", \"callbackDate\": \"\"}, {\"date\": \"6/27/2024 @ 07:45 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Moira Roethle\", \"callbackDate\": \"7/4/2024 @ 07:45 PM\"}, {\"date\": \"5/20/2024 @ 04:38 PM\", \"result\": 3, \"comment\": \"LEFT A VOICEMAIL-Call attempt to schedule a virtual HRA.\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"5/21/2024 @ 04:38 PM\"}, {\"date\": \"5/17/2024 @ 12:09 PM\", \"result\": 3, \"comment\": \"LEFT A VOICEMAIL-Call attempt to schedule a virtual HRA.\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"5/20/2024 @ 12:09 PM\"}, {\"date\": \"5/10/2024 @ 06:58 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Moira Roethle\", \"callbackDate\": \"5/11/2024 @ 06:57 PM\"}], \"clinicianId\": \"\", \"appointmentDate\": \"\"}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"05-10-2024 18:58:00\", \"schedulerId\": \"2661185\", \"schedulerLeadId\": \"2661185\"}]}', '{\"date\": \"07-02-2024 18:23:23\", \"status\": 3, \"details\": \"moved to utc\", \"disabled\": true, \"notification\": null}', '{\"attemptCount\": 7}', NULL, 1, NULL, NULL, NULL, NULL, '2024-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '21-04-2024 05:59:31', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(1531, NULL, NULL, NULL, '0006030271001', '365293', '', '26056802', 'MARIA', 'BONILLA', '', '{\"DOB\": 21719, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"On Exchange\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Alliant\", \"HBA1C\": \"N\", \"Aligned\": \"N\", \"Pcp_Zip\": \"\", \"Program\": \"ACA\", \"PCP_Flag\": \"1\", \"Pcp_City\": \"\", \"Pcp_Name\": \" \", \"PCP_Phone\": \"\", \"Member_City\": \"Oakwood\", \"Office_Name\": \"\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Oakwood\", \"Member_State\": \"GA\", \"Date_Of_Birth\": \"1959-06-18\", \"Mailing_State\": \"GA\", \"Member_Gender\": \"F\", \"Member_Region\": \"\", \"Pcp_Address_1\": \"\", \"Screening_IHA\": \"No\", \"member_id_two\": 365293, \"Mailing_County\": \"HALL\", \"Member_Country\": \"HALL\", \"PCP_Fax_Number\": \"\", \"Plan_Term_Date\": \"2024-12-31\", \"Member_Address1\": \"4509 Prestwick Dr\", \"Member_Address2\": \"\", \"Member_Zip_Code\": 30566, \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"4509 Prestwick Dr\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": 30566, \"Member_Ethnicity\": \"Hispanic, Latino, or Spanish Origin\", \"Member_Last_name\": \"BONILLA\", \"Medication_Review\": \"N\", \"Member_first_name\": \"MARIA\", \"Member_Middle_name\": \"A\", \"Plan_Effective_Date\": 45292, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"\", \"Member_Suspect_Codes\": 21, \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Phone_Number\": 7709125092, \"Member_Identification_Number\": \"0006030271001\", \"Member_Alternate_Phone_Number\": \"\"}', 'client_009', '2024', '', '{\"hraStatus\":18,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'1', b'1', '{\"date\": \"11-22-2024 23:30:16\", \"text\": \"Termed\", \"method\": \"auto\", \"status\": 22}', '{\"cron\": \"3\", \"date\": \"2024-11-22 23:30:16\", \"hrastatus\": 18, \"reportstatus\": \"\"}', '{\"LVM\": [], \"utc\": [{\"date\": \"2024-07-11T13:39\", \"text\": \"UTC\", \"method\": \"api\", \"status\": 19}], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2024-04-30T19:34\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-05-13T12:29\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-06-04T13:23\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-06-05T19:15\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-07-11T13:39\", \"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-30T19:34\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-05-13T12:29\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-06-05T19:15\"}, {\"text\": \"UTC\", \"type\": \"ReportStatus\", \"status\": 19, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-07-11T13:39\"}]', NULL, '{\"history\": [{\"modified\": [{\"date\": \"04-21-2024\", \"time\": \"05:59:31\", \"value\": [{\"add\": \"4509 Prestwick Dr\", \"age\": \"\", \"ano\": \"\", \"cno\": \"\", \"dob\": \"1959-06-18\", \"eno\": \"\", \"lob\": \"On Exchange\", \"pno\": 7709125092, \"zip\": 30566, \"add2\": \"\", \"add3\": \"\", \"city\": \"Oakwood\", \"gend\": 1, \"insh\": \"0006030271001\", \"mzip\": 30566, \"name\": \"MARIA A BONILLA\", \"plan\": \"Alliant\", \"pphy\": \" \", \"ppno\": \"\", \"cliId\": \"\", \"email\": \"\", \"ename\": \"\", \"madd1\": \"4509 Prestwick Dr\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Oakwood\", \"pcpid\": \"\", \"state\": \"GA\", \"mstate\": \"GA\", \"pcpadd\": \"\", \"pcpnpi\": \"\", \"pcpzip\": \"\", \"region\": \"\", \"aligned\": \"N\", \"mstatus\": \"\", \"pcpcity\": \"\", \"pcpname\": \"\", \"program\": \"ACA\", \"pcpfaxno\": \"\", \"pcpstate\": \"\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"\", \"currentgend\": \"\", \"pphycomment\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": {\"sub\": [], \"indx\": [[\"No Ethnicity\"]], \"comment\": [[\"\"]]}, \"indx\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"1\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": []}, {\"a\": []}, {\"a\": []}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"05-11-2024\", \"time\": \"03:24:44\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"05-11-2024 03:24:44\"}', NULL, NULL, NULL, '{\"utc\": false, \"result\": 13, \"callLog\": [{\"date\": \"11/1/2024 @ 03:29 PM\", \"result\": 13, \"comment\": \"Called Member to set up virtual HRA, 6 attempt Caller Disconnected-LB\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Latoya Bagley\", \"callbackDate\": \"\"}, {\"date\": \"8/19/2024 @ 01:22 PM\", \"result\": 1, \"comment\": \"Called to Schedule Virtual HRA with Debbie , dead air.\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Melissa Trevino\", \"callbackDate\": \"\"}, {\"date\": \"7/30/2024 @ 05:48 PM\", \"result\": 1, \"comment\": \"Called to schedule HRA w/ DELISE ADAMS Dead Air.\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Tressa  Scott\", \"callbackDate\": \"\"}, {\"date\": \"7/15/2024 @ 05:55 PM\", \"result\": 3, \"comment\": \"Call attempt to schedule a virtual HRA w/ Delise Adams. - LVM\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"\"}, {\"date\": \"7/11/2024 @ 01:39 PM\", \"result\": 13, \"comment\": \"CALLER DISCONNECTED the call prior to and/or after greeting. Call attempt to schedule HRA. \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Jasmine Crawford\", \"callbackDate\": \"\"}, {\"date\": \"6/5/2024 @ 07:15 PM\", \"result\": 3, \"comment\": \"Called to schedule F2F HRA w/ Delise Adams \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Lakisha Stewart\", \"callbackDate\": \"6/12/2024 @ 07:14 PM\"}, {\"date\": \"6/4/2024 @ 01:23 PM\", \"result\": 13, \"comment\": \"Called to schedule F2F HRA w/ Delise Adams \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Lakisha Stewart\", \"callbackDate\": \"6/11/2024 @ 01:23 PM\"}, {\"date\": \"5/13/2024 @ 12:29 PM\", \"result\": 13, \"comment\": \"5/13/24 GM: Called to Schedule Virtual HRA with Sally Key.  member disconnected \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Grace Medrano\", \"callbackDate\": \"5/14/2024 @ 12:29 PM\"}, {\"date\": \"4/30/2024 @ 07:34 PM\", \"result\": 13, \"comment\": \"Called to schedule F2F HRA w/ Delise Adams - Caller Disconnected\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Lakisha Stewart\", \"callbackDate\": \"5/14/2024 @ 07:33 PM\"}], \"clinicianId\": \"\", \"appointmentDate\": \"\"}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"04-30-2024 19:34:00\", \"schedulerId\": \"26056802\", \"schedulerLeadId\": \"26056802\"}]}', '{\"date\": \"07-11-2024 13:39:40\", \"status\": 3, \"details\": \"moved to utc\", \"disabled\": true, \"notification\": null}', '{\"attemptCount\": 9}', NULL, 1, NULL, NULL, NULL, NULL, '2024-10-31', NULL, NULL, NULL, NULL, NULL, '123456789', '21-04-2024 05:59:31', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(1532, NULL, NULL, NULL, '0006030897002', '345037', '', NULL, 'Dipti', 'Patel', '', '{\"DOB\": 25883, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"On Exchange\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Alliant\", \"HBA1C\": \"N\", \"Aligned\": \"N\", \"PCP_NPI\": 1548385966, \"Pcp_Zip\": \"\", \"Program\": \"ACA\", \"PCP_Flag\": \"1\", \"Pcp_City\": \"MACON\", \"Pcp_Name\": \"JAYESH PATEL\", \"PCP_Phone\": 4784770966, \"Pcp_State\": \"GA\", \"Member_City\": \"Warner Robins\", \"Office_Name\": \"\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Warner Robins\", \"Member_State\": \"GA\", \"Date_Of_Birth\": \"1970-11-11\", \"Mailing_State\": \"GA\", \"Member_Gender\": \"F\", \"Member_Region\": \"\", \"Pcp_Address_1\": \"197 BASS RD\", \"Screening_IHA\": \"No\", \"member_id_two\": 345037, \"Mailing_County\": \"HOUSTON\", \"Member_Country\": \"HOUSTON\", \"PCP_Fax_Number\": \"\", \"Plan_Term_Date\": \"2024-12-31\", \"Member_Address1\": \"215 Sedgebrooke Dr\", \"Member_Address2\": \"\", \"Member_Zip_Code\": 310880000, \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"215 Sedgebrooke Dr\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": 31088, \"Member_Last_name\": \"Patel\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Dipti\", \"Plan_Effective_Date\": 45292, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"\", \"Member_Suspect_Codes\": 21, \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Phone_Number\": \"\", \"Member_Identification_Number\": \"0006030897002\", \"Member_Alternate_Phone_Number\": \"\"}', 'client_009', '2024', '', '{\"hraStatus\":18,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'0', b'0', '{\"date\": \"01-01-2025 23:33:06\", \"text\": \"Termed\", \"method\": \"auto\", \"status\": 22}', '{\"cron\": \"3\", \"date\": \"2025-01-01 23:33:06\", \"hrastatus\": 18, \"reportstatus\": \"\"}', NULL, NULL, NULL, '{\"history\": [{\"modified\": [{\"date\": \"04-21-2024\", \"time\": \"05:59:31\", \"value\": [{\"add\": \"215 Sedgebrooke Dr\", \"age\": \"\", \"ano\": \"\", \"cno\": \"\", \"dob\": \"1970-11-11\", \"eno\": \"\", \"lob\": \"On Exchange\", \"pno\": \"\", \"zip\": 310880000, \"add2\": \"\", \"add3\": \"\", \"city\": \"Warner Robins\", \"gend\": 1, \"insh\": \"0006030897002\", \"mzip\": 31088, \"name\": \"Dipti Patel\", \"plan\": \"Alliant\", \"pphy\": \"JAYESH PATEL\", \"ppno\": 4784770966, \"cliId\": \"\", \"email\": \"\", \"ename\": \"\", \"madd1\": \"215 Sedgebrooke Dr\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Warner Robins\", \"pcpid\": \"\", \"state\": \"GA\", \"mstate\": \"GA\", \"pcpadd\": \"197 BASS RD\", \"pcpnpi\": 1548385966, \"pcpzip\": \"\", \"region\": \"\", \"aligned\": \"N\", \"mstatus\": \"\", \"pcpcity\": \"MACON\", \"pcpname\": \"\", \"program\": \"ACA\", \"pcpfaxno\": \"\", \"pcpstate\": \"GA\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"\", \"currentgend\": \"\", \"pphycomment\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": {\"sub\": [], \"indx\": [[\"No Ethnicity\"]], \"comment\": [[\"\"]]}, \"indx\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"1\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": []}, {\"a\": []}, {\"a\": []}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"05-11-2024\", \"time\": \"03:24:44\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"05-11-2024 03:24:44\"}', NULL, NULL, NULL, NULL, NULL, '{\"date\": \"04-22-2024 00:31:20\", \"status\": 0, \"details\": \"previous year member 10 months exceeded\", \"disabled\": false, \"notification\": null}', NULL, NULL, 1, NULL, NULL, NULL, NULL, '2024-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '21-04-2024 05:59:31', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(1533, NULL, NULL, NULL, '0006033010001', '387516', '', '2661185', 'James', 'Hurt', '', '{\"DOB\": 24395, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"On Exchange\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Alliant\", \"HBA1C\": \"N\", \"Aligned\": \"N\", \"PCP_NPI\": 1386710085, \"Pcp_Zip\": \"\", \"Program\": \"ACA\", \"PCP_Flag\": \"1\", \"Pcp_City\": \"CLAYTON\", \"Pcp_Name\": \"EDWARD FREDERICKSON\", \"PCP_Phone\": 7067824799, \"Pcp_State\": \"GA\", \"Member_City\": \"Lakemont\", \"Office_Name\": \"\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Lakemont\", \"Member_State\": \"GA\", \"Date_Of_Birth\": \"1966-10-15\", \"Mailing_State\": \"GA\", \"Member_Gender\": \"M\", \"Member_Region\": \"\", \"Pcp_Address_1\": \"156 N MAIN ST\", \"Screening_IHA\": \"No\", \"member_id_two\": 387516, \"Mailing_County\": \"RABUN\", \"Member_Country\": \"RABUN\", \"PCP_Fax_Number\": \"\", \"Plan_Term_Date\": \"2024-12-31\", \"Member_Address1\": \"284 Morning Glory Ln\", \"Member_Address2\": \"\", \"Member_Zip_Code\": 30552, \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"284 Morning Glory Ln\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": 30552, \"Member_Last_name\": \"Hurt\", \"Medication_Review\": \"N\", \"Member_first_name\": \"James\", \"Plan_Effective_Date\": 45292, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"ehurt@hurtstolz.com\", \"Member_Suspect_Codes\": \"21, 22\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Phone_Number\": 4045937141, \"Member_Identification_Number\": \"0006033010001\", \"Member_Alternate_Phone_Number\": \"\"}', 'client_009', '2024', '', '{\"hraStatus\":18,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'1', b'1', '{\"date\": \"01-01-2025 23:33:06\", \"text\": \"Termed\", \"method\": \"auto\", \"status\": 22}', '{\"cron\": \"3\", \"date\": \"2025-01-01 23:33:06\", \"hrastatus\": 18, \"reportstatus\": \"\"}', '{\"LVM\": [], \"utc\": [{\"date\": \"2024-07-03T17:40\", \"text\": \"UTC\", \"method\": \"api\", \"status\": 19}], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2024-05-10T18:59\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-05-17T12:09\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-05-20T16:39\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-06-27T19:46\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-07-03T17:40\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [], \"disconnected\": [], \"virtualNoShow\": [], \"callBackRequested\": [], \"callerDisconnected\": []}', '[{\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": \"\", \"hraStatus_date\": \"\", \"reportStatus_date\": \"2024-05-10T18:59\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-05-20T16:39\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-06-27T19:46\"}, {\"text\": \"UTC\", \"type\": \"ReportStatus\", \"status\": 19, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-07-03T17:40\"}]', '{\"utc\": [{\"date\": \"2024-07-17T13:15\", \"username\": null}], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [], \"scheduled\": [], \"inProgress\": [], \"qaAssigned\": [], \"readyForQa\": [], \"inEligibile\": [], \"termExpired\": [], \"preScheduled\": [], \"coderAssigned\": [], \"readyForCoder\": [], \"patientRefusal\": [], \"readyForUpload\": [], \"clinicianReviewQa\": [], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": []}', '{\"history\": [{\"modified\": [{\"date\": \"04-21-2024\", \"time\": \"05:59:32\", \"value\": [{\"add\": \"284 Morning Glory Ln\", \"age\": \"\", \"ano\": \"\", \"cno\": \"\", \"dob\": \"1966-10-15\", \"eno\": \"\", \"lob\": \"On Exchange\", \"pno\": 4045937141, \"zip\": 30552, \"add2\": \"\", \"add3\": \"\", \"city\": \"Lakemont\", \"gend\": 0, \"insh\": \"0006033010001\", \"mzip\": 30552, \"name\": \"James Hurt\", \"plan\": \"Alliant\", \"pphy\": \"EDWARD FREDERICKSON\", \"ppno\": 7067824799, \"cliId\": \"\", \"email\": \"ehurt@hurtstolz.com\", \"ename\": \"\", \"madd1\": \"284 Morning Glory Ln\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Lakemont\", \"pcpid\": \"\", \"state\": \"GA\", \"mstate\": \"GA\", \"pcpadd\": \"156 N MAIN ST\", \"pcpnpi\": 1386710085, \"pcpzip\": \"\", \"region\": \"\", \"aligned\": \"N\", \"mstatus\": \"\", \"pcpcity\": \"CLAYTON\", \"pcpname\": \"\", \"program\": \"ACA\", \"pcpfaxno\": \"\", \"pcpstate\": \"GA\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"\", \"currentgend\": \"\", \"pphycomment\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": {\"sub\": [], \"indx\": [[\"No Ethnicity\"]], \"comment\": [[\"\"]]}, \"indx\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"1\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": []}, {\"a\": []}, {\"a\": []}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"05-11-2024\", \"time\": \"03:24:44\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"05-11-2024 03:24:44\"}', NULL, NULL, NULL, '{\"utc\": false, \"result\": 3, \"callLog\": [{\"date\": \"11/6/2024 @ 01:51 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"\"}, {\"date\": \"11/1/2024 @ 09:45 AM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"\"}, {\"date\": \"9/9/2024 @ 01:19 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Mariana Bernard\", \"callbackDate\": \"\"}, {\"date\": \"8/1/2024 @ 01:59 PM\", \"result\": 3, \"comment\": \" Called to schedule HRA w/ DELISE ADAMS lvm. \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Tressa  Scott\", \"callbackDate\": \"\"}, {\"date\": \"7/18/2024 @ 04:29 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Jasmine Crawford\", \"callbackDate\": \"\"}, {\"date\": \"7/3/2024 @ 05:40 PM\", \"result\": 3, \"comment\": \"Called to schedule HRA w/ Faith Enwefah\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Tressa  Scott\", \"callbackDate\": \"\"}, {\"date\": \"6/27/2024 @ 07:46 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Moira Roethle\", \"callbackDate\": \"7/4/2024 @ 07:46 PM\"}, {\"date\": \"5/20/2024 @ 04:39 PM\", \"result\": 3, \"comment\": \"Called to schedule Virtual HRA w/ Faith Enwefah - LVM\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Lakisha Stewart\", \"callbackDate\": \"5/27/2024 @ 04:39 PM\"}, {\"date\": \"5/17/2024 @ 12:09 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Moira Roethle\", \"callbackDate\": \"5/18/2024 @ 12:08 PM\"}, {\"date\": \"5/10/2024 @ 06:59 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Moira Roethle\", \"callbackDate\": \"5/11/2024 @ 06:59 PM\"}], \"clinicianId\": \"\", \"appointmentDate\": \"\"}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"05-10-2024 18:59:00\", \"schedulerId\": \"2661185\", \"schedulerLeadId\": \"2661185\"}]}', '{\"date\": \"07-03-2024 17:40:14\", \"status\": 3, \"details\": \"moved to utc\", \"disabled\": true, \"notification\": null}', '{\"attemptCount\": 10}', NULL, 1, NULL, NULL, NULL, NULL, '2024-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '21-04-2024 05:59:32', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(1534, NULL, NULL, NULL, '0006034744001', '356193', '', '84555898', 'Jimmy', 'Henley', '', '{\"DOB\": 25038, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"On Exchange\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Alliant\", \"HBA1C\": \"N\", \"Aligned\": \"N\", \"PCP_NPI\": 1003966094, \"Pcp_Zip\": \"\", \"Program\": \"ACA\", \"PCP_Flag\": \"1\", \"Pcp_City\": \"FAYETTEVILLE\", \"Pcp_Name\": \"GERALD SLAGEL\", \"PCP_Phone\": 7704604283, \"Pcp_State\": \"GA\", \"Member_City\": \"Griffin\", \"Office_Name\": \"\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Griffin\", \"Member_State\": \"GA\", \"Date_Of_Birth\": \"1968-07-19\", \"Mailing_State\": \"GA\", \"Member_Gender\": \"M\", \"Member_Region\": \"\", \"Pcp_Address_1\": \"101 YORKTOWN DR SUITE 207\", \"Screening_IHA\": \"No\", \"member_id_two\": 356193, \"Mailing_County\": \"PIKE\", \"Member_Country\": \"PIKE\", \"PCP_Fax_Number\": \"\", \"Plan_Term_Date\": \"2024-12-31\", \"Member_Address1\": \"233 Ellis Circle\", \"Member_Address2\": \"\", \"Member_Zip_Code\": 302240000, \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"233 Ellis Circle\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": 30224, \"Member_Last_name\": \"Henley\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Jimmy\", \"Plan_Effective_Date\": 45292, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"henleyjimmylee@aol.com\", \"Member_Suspect_Codes\": 21, \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Phone_Number\": 6785237776, \"Member_Identification_Number\": \"0006034744001\", \"Member_Alternate_Phone_Number\": \"\"}', 'client_009', '2024', '', '{\"hraStatus\":18,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'1', b'1', '{\"date\": \"01-01-2025 23:33:06\", \"text\": \"Termed\", \"method\": \"auto\", \"status\": 22}', '{\"cron\": \"3\", \"date\": \"2025-01-01 23:33:06\", \"hrastatus\": 18, \"reportstatus\": \"\"}', '{\"LVM\": [], \"utc\": [{\"date\": \"2024-07-15T17:55\", \"text\": \"UTC\", \"method\": \"api\", \"status\": 19}], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2024-06-04T15:01\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-07-09T12:29\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-07-11T13:40\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-07-15T17:55\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [], \"disconnected\": [], \"virtualNoShow\": [], \"callBackRequested\": [{\"date\": \"2024-06-06T17:05\", \"text\": \"Call Back\", \"method\": \"api\", \"status\": 9}], \"callerDisconnected\": []}', '[{\"text\": \"Call Back\", \"type\": \"ReportStatus\", \"status\": 9, \"hraStatus\": \"\", \"hraStatus_date\": \"\", \"reportStatus_date\": \"2024-06-06T17:05\"}, {\"text\": \"UTC\", \"type\": \"ReportStatus\", \"status\": 19, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-07-15T17:55\"}]', '{\"utc\": [{\"date\": \"2024-07-17T13:15\", \"username\": null}], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [], \"scheduled\": [], \"inProgress\": [], \"qaAssigned\": [], \"readyForQa\": [], \"inEligibile\": [], \"termExpired\": [], \"preScheduled\": [], \"coderAssigned\": [], \"readyForCoder\": [], \"patientRefusal\": [], \"readyForUpload\": [], \"clinicianReviewQa\": [], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": []}', '{\"history\": [{\"modified\": [{\"date\": \"04-21-2024\", \"time\": \"05:59:32\", \"value\": [{\"add\": \"233 Ellis Circle\", \"age\": \"\", \"ano\": \"\", \"cno\": \"\", \"dob\": \"1968-07-19\", \"eno\": \"\", \"lob\": \"On Exchange\", \"pno\": 6785237776, \"zip\": 302240000, \"add2\": \"\", \"add3\": \"\", \"city\": \"Griffin\", \"gend\": 0, \"insh\": \"0006034744001\", \"mzip\": 30224, \"name\": \"Jimmy Henley\", \"plan\": \"Alliant\", \"pphy\": \"GERALD SLAGEL\", \"ppno\": 7704604283, \"cliId\": \"\", \"email\": \"henleyjimmylee@aol.com\", \"ename\": \"\", \"madd1\": \"233 Ellis Circle\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Griffin\", \"pcpid\": \"\", \"state\": \"GA\", \"mstate\": \"GA\", \"pcpadd\": \"101 YORKTOWN DR SUITE 207\", \"pcpnpi\": 1003966094, \"pcpzip\": \"\", \"region\": \"\", \"aligned\": \"N\", \"mstatus\": \"\", \"pcpcity\": \"FAYETTEVILLE\", \"pcpname\": \"\", \"program\": \"ACA\", \"pcpfaxno\": \"\", \"pcpstate\": \"GA\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"\", \"currentgend\": \"\", \"pphycomment\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": {\"sub\": [], \"indx\": [[\"No Ethnicity\"]], \"comment\": [[\"\"]]}, \"indx\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"1\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": []}, {\"a\": []}, {\"a\": []}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"05-11-2024\", \"time\": \"03:24:44\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"05-11-2024 03:24:44\"}', NULL, NULL, NULL, '{\"utc\": false, \"result\": 3, \"callLog\": [{\"date\": \"10/31/2024 @ 04:47 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"\"}, {\"date\": \"9/9/2024 @ 11:35 AM\", \"result\": 3, \"comment\": \"Call attempt to schedule a virtual HRA w/ Tiana Proctor.  - LVM\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"\"}, {\"date\": \"7/31/2024 @ 05:32 PM\", \"result\": 3, \"comment\": \"Called to schedule HRA w/ DELISE ADAMS lvm.\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Tressa  Scott\", \"callbackDate\": \"\"}, {\"date\": \"7/17/2024 @ 01:18 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Jasmine Crawford\", \"callbackDate\": \"\"}, {\"date\": \"7/15/2024 @ 05:55 PM\", \"result\": 3, \"comment\": \"07/15/2024 JC: called for HRA-Connie Middleton-Virtual: LVM  \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Julisa Copeland\", \"callbackDate\": \"\"}, {\"date\": \"7/11/2024 @ 01:40 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Jasmine Crawford\", \"callbackDate\": \"7/12/2024 @ 01:40 PM\"}, {\"date\": \"7/9/2024 @ 12:29 PM\", \"result\": 3, \"comment\": \"Called to schedule HRA w/ FAITH ENWEFAH\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Tressa  Scott\", \"callbackDate\": \"7/22/2024 @ 12:29 PM\"}, {\"date\": \"6/6/2024 @ 05:05 PM\", \"result\": 6, \"comment\": \"CALL BACK VIRTUAL VISIT WITH DEBORAH YORK WANTS TO CALL ALLIANT DID NOT FEEL COMFORTABLE MV \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Mary Valdez\", \"callbackDate\": \"6/11/2024 @ 05:05 PM\"}, {\"date\": \"6/4/2024 @ 03:01 PM\", \"result\": 3, \"comment\": \"LEFT A VOICEMAIL- Call attempt to schedule a virtual HRA.\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Jasmine Crawford\", \"callbackDate\": \"6/5/2024 @ 03:01 PM\"}], \"clinicianId\": \"\", \"appointmentDate\": \"\"}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"06-04-2024 15:01:00\", \"schedulerId\": \"84555898\", \"schedulerLeadId\": \"84555898\"}]}', '{\"date\": \"07-15-2024 17:55:57\", \"status\": 3, \"details\": \"moved to utc\", \"disabled\": true, \"notification\": null}', '{\"attemptCount\": 9}', NULL, 1, NULL, NULL, NULL, NULL, '2024-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '21-04-2024 05:59:32', 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
(1535, 50892900, 44829497, '37129221', '0006035259001', '380526', '', '26056802', 'Ronald', 'Weaver', '', '{\"DOB\": 21750, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"On Exchange\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Alliant\", \"HBA1C\": \"N\", \"Notes\": \"Fax Not Sent\", \"Aligned\": \"N\", \"PCP_NPI\": 1417980558, \"Pcp_Zip\": \"30517\", \"Program\": \"ACA\", \"PCP_Flag\": \"1\", \"Pcp_City\": \"Braselton\", \"Pcp_Name\": \"Dr. Nikeva Johnson\", \"PCP_Phone\": \"770-848-6140\", \"Pcp_State\": \"GA\", \"Member_City\": \"Braselton\", \"Office_Name\": \"\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Braselton\", \"Member_State\": \"GA\", \"Date_Of_Birth\": \"1959-07-19\", \"Mailing_State\": \"GA\", \"Member_Gender\": \"M\", \"Member_Region\": \"\", \"Pcp_Address_1\": \"1515 Riverplace Ste. 200\", \"Screening_IHA\": \"No\", \"member_id_two\": 380526, \"Mailing_County\": \"HALL\", \"Member_Country\": \"HALL\", \"PCP_Fax_Number\": \"7708486141\", \"Plan_Term_Date\": \"2024-12-31\", \"Member_Address1\": \"4226 Benefield Rd\", \"Member_Address2\": \"\", \"Member_Zip_Code\": 30517, \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"4226 Benefield Rd\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": 30517, \"Member_Last_name\": \"Weaver\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Ronald\", \"Plan_Effective_Date\": 45292, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_CurrentGender\": \"Male\", \"Member_Email_Address\": \"rweaver4226@att.net\", \"Member_Suspect_Codes\": \"20, 21\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Successful_Reaching_PCP\": \"No\", \"Member_Primary_Phone_Number\": 6784279416, \"Member_Identification_Number\": \"0006035259001\", \"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:34:31\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}', '{\"date\": \"2024-05-31 14:34:31\", \"hrastatus\": \"\", \"reportstatus\": \"Completed\"}', '{\"LVM\": [], \"utc\": [], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [{\"date\": \"2024-05-07T08:53\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2024-05-10T13:31\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2024-05-11T13:15\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2024-05-31T14:34\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [{\"date\": \"2024-04-25T19:32\", \"text\": \"Scheduled\", \"method\": \"api\", \"status\": 0}, {\"date\": \"2024-04-26T16:08\", \"text\": \"Scheduled\", \"method\": \"api\", \"status\": 0}, {\"date\": \"2024-05-03T17:07\", \"text\": \"Scheduled\", \"method\": \"api\", \"status\": 0}, {\"date\": \"2024-05-03T17:08\", \"text\": \"Scheduled\", \"method\": \"api\", \"status\": 0}], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [{\"date\": \"2024-04-29T14:15\", \"text\": \"Rescheduled\", \"method\": \"api\", \"status\": 16}], \"wrongNumber\": [], \"cancellation\": [{\"date\": \"2024-04-30T12:28\", \"text\": \"Cancellation\", \"method\": \"api\", \"status\": 18}], \"disconnected\": [], \"virtualNoShow\": [], \"callBackRequested\": [], \"callerDisconnected\": []}', '[{\"text\": \"Rescheduled\", \"type\": \"HraStatus\", \"status\": 16, \"hraStatus\": 1, \"hraStatus_date\": \"2024-04-29T14:15\", \"reportStatus_date\": \"2024-04-29T14:15\"}, {\"text\": \"Scheduled\", \"type\": \"HraStatus\", \"status\": 0, \"hraStatus\": 2, \"hraStatus_date\": \"2024-05-06T12:17\", \"reportStatus_date\": \"2024-05-03T17:08\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 10, \"hraStatus_date\": \"2024-05-11T13:15\", \"reportStatus_date\": \"2024-05-11T13:15\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 11, \"hraStatus_date\": \"2024-05-31T14:34\", \"reportStatus_date\": \"2024-05-31T14:34\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [{\"date\": \"2024-05-31T14:34\", \"username\": null}], \"scheduled\": [{\"date\": \"2024-04-25T19:32\", \"username\": null}, {\"date\": \"2024-04-25T19:32\", \"username\": null}, {\"date\": \"2024-04-26T16:08\", \"username\": null}, {\"date\": \"2024-04-29T14:15\", \"username\": null}, {\"date\": \"2024-04-29T14:15\", \"username\": null}, {\"date\": \"2024-05-03T17:07\", \"username\": \"TOdleAdmin\"}, {\"date\": \"2024-05-03T17:08\", \"username\": null}], \"inProgress\": [{\"date\": \"2024-05-06T12:17\", \"username\": \"SKey\"}], \"qaAssigned\": [{\"date\": \"2024-05-08T08:19\", \"username\": \"JScanlonQAL\"}], \"readyForQa\": [{\"date\": \"2024-05-07T08:53\", \"username\": \"SKey\"}, {\"date\": \"2024-05-08T15:55\", \"username\": \"SKey\"}], \"inEligibile\": [], \"termExpired\": [], \"preScheduled\": [], \"coderAssigned\": [{\"date\": \"2024-05-11T13:15\", \"username\": \"JWren1\"}], \"readyForCoder\": [{\"date\": \"2024-05-10T13:31\", \"username\": \"fcopeland1\"}], \"patientRefusal\": [], \"readyForUpload\": [{\"date\": \"2024-05-11T13:15\", \"username\": \"JWren1\"}], \"clinicianReviewQa\": [{\"date\": \"2024-05-08T09:44\", \"username\": \"fcopeland1\"}], \"assessmentCalcelled\": [], \"appointmentCancelled\": [{\"date\": \"2024-04-30T12:28\", \"username\": \"PFrey1\"}], \"clinicianReviewCoder\": []}', '{\"history\": [{\"modified\": [{\"date\": \"07-01-2024\", \"time\": \"10:49:33\", \"value\": [{\"add\": \"4226 Benefield Rd\", \"age\": 64, \"ano\": \"\", \"cno\": \"\", \"dob\": \"1959-07-19\", \"eno\": \"770-539-2234\", \"lob\": \"On Exchange\", \"pno\": 6784279416, \"zip\": 30517, \"add2\": \"\", \"add3\": \"\", \"city\": \"Braselton\", \"gend\": 0, \"insh\": \"0006035259001\", \"mzip\": 30517, \"name\": \"Ronald Weaver\", \"plan\": \"Alliant\", \"pphy\": \"Dr. Nikeva Johnson\", \"ppno\": \"770-848-6140\", \"race\": \"\", \"cliId\": \"\", \"email\": \"rweaver4226@att.net\", \"ename\": \"Janet Weaver\", \"madd1\": \"4226 Benefield Rd\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Braselton\", \"pcpid\": \"\", \"state\": \"GA\", \"mstate\": \"GA\", \"pcpadd\": \"1515 Riverplace Ste. 200\", \"pcpnpi\": 1417980558, \"pcpzip\": \"30517\", \"region\": \"\", \"aligned\": \"N\", \"mstatus\": \"Married\", \"pcpcity\": \"Braselton\", \"pcpname\": \"\", \"program\": \"ACA\", \"evalDate\": \"2024-05-06 12:00 PM\", \"evalName\": \"Sallie Key, FNP\", \"pcpfaxno\": \"7708486141\", \"pcpstate\": \"GA\", \"uniqueid\": \"\", \"pcpcounty\": \"Hall\", \"medicaidid\": \"\", \"medicareid\": \"\", \"currentgend\": \"Male\", \"pphycomment\": \"\", \"primaryLanguage\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"\", \"1\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\"], \"comment\": [\"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"\", \"1\"], \"comment\": [\"\", \"\"]}}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"05-11-2024\", \"time\": \"03:24:44\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"07-01-2024 10:49:33\"}', '{\"utc\": [], \"noShow\": [], \"patientRefusal\": [], \"appointmentCancelled\": [{\"date\": \"2024-04-30T12:28\", \"type\": \"In Person\", \"subStaus\": \"\", \"username\": \"PFrey1\", \"hraStatus\": 3, \"cancelText\": \"Provider Cancellation\", \"cancelStatus\": 1}]}', NULL, '{\"memberId\": \"0006035259001\", \"clinician\": \"Sallie Key\", \"qaAnalyst\": \"Felecia Copeland\", \"queryData\": [{\"date\": \"Wed, 08 May 2024 13:48:46 GMT\", \"name\": \"Felecia \", \"role\": \"qa\", \"files\": [], \"query\": {\"feedback\": \"Hi Sallie,\\n     Thanks for all you do for our members!  Please review, reconcile and kindly re-submit within 24hrs: \\n1. MEDICATIONS-insulin pen, and Cominarty-please indicate \\\"taking or not taking\\\"?\\n2. EYE-Symptoms appear blank-please complete\\n3. GI-chronic constipation is indicated, use comment bubble to indicate any OTC use, etc. and check recommendation box if applicable\\n4. ENDO-recommendation box-please check the \\\"take medications as prescribed\\\" box.  This validates that we are educating our members regarding use of their medications\\n5. CANCER-please answer the question here as it appears blank\\n\", \"response\": \"\"}, \"mailId\": \"\"}, {\"date\": \"Wed, 08 May 2024 19:55:57 GMT\", \"name\": \"Sallie \", \"role\": \"nurse\", \"files\": [], \"query\": {\"feedback\": \"\", \"response\": \"edited Patient encounter\"}, \"mailId\": \"\"}], \"memberName\": \"Ronald Weaver\", \"codingAnalyst\": \"\", \"dateOfService\": \"05/06/2024 12:00 PM\", \"clinicianMailId\": \"s.key@focuscares.com\", \"qaAnalystMailId\": \"fcopeland@focuscares.com\", \"codingAnalystMailId\": \"\"}', '{\"utc\": false, \"result\": 12, \"callLog\": [{\"date\": \"4/29/2024 @ 02:15 PM\", \"result\": 12, \"comment\": \"Rescheduled F2F HRA w/ Sallie Key on 5/6 - PM - 130PM - 430PM \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Lakisha Stewart\", \"callbackDate\": \"\"}, {\"date\": \"4/25/2024 @ 07:32 PM\", \"result\": 0, \"comment\": \"Scheduled F2F HRA w/ Sallie Key on 4/29 @ 3pm \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Lakisha Stewart\", \"callbackDate\": \"\"}], \"visitType\": {\"type\": \"visitType\", \"memberId\": \"0006035259001\", \"visitType\": \"In Person\"}, \"clinicianId\": {\"type\": \"assignMember\", \"nurseId\": \"37129221\", \"memberId\": \"0006035259001\"}, \"appointmentDate\": {\"type\": \"scheduleDate\", \"nurseId\": \"37129221\", \"memberId\": \"0006035259001\", \"scheduleDate\": \"2024-5-6T12:00\"}}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"04-25-2024 19:32:00\", \"schedulerId\": \"26056802\", \"schedulerLeadId\": \"26056802\"}, {\"date\": \"04-30-2024 12:28:40\", \"schedulerId\": \"26056802\", \"schedulerLeadId\": \"26056802\"}]}', '{\"date\": \"05-03-2024 17:08:08\", \"status\": 1, \"details\": \"scheduled directly\", \"disabled\": false, \"notification\": null}', '{\"attemptCount\": 2}', '{\"orderType\": 1, \"sortOrder\": 1714494520}', 0, NULL, '[{\"date\": \"2024-05-31 14:34:29\", \"status\": 0, \"message\": \"Fax sent failed\", \"fax_response\": \"{\\\"transaction_id\\\":\\\"6aa1a9cb-1f7c-11ef-b6bb-970b58e7b186\\\",\\\"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-6T13:00', '2024-12-31', '2024-05-06T12:00', NULL, NULL, NULL, NULL, '123456789', '21-04-2024 05:59:32', NULL, NULL, NULL, NULL, '{\"year\": \"2024\", \"client_id\": \"client_009\", \"member_id\": \"0006035259001\", \"reason_hra\": \"uploaded for HRA Assessment\", \"reason_summary\": \"uploaded for Summary Assessment\", \"assessment_name\": \"ACA_0006035259001_Weaver, Ronald_05062024.pdf\", \"ftp_upload_date\": \"2024-05-31 14:34:29\", \"hra_uploadStatus\": \"success\", \"summary_uploadStats\": \"success\", \"summary_assessment_name\": \"PCP_Johnson, Nikeva_0006035259001_05062024.pdf\"}', 'ACA_0006035259001_Weaver, Ronald_05062024', NULL, 'PCP_Johnson, Nikeva_0006035259001_05062024', NULL, '[{\"date\": \"2024-05-07T12:53:29.143Z\", \"signature\": \"data:image/png;base64,[encoded data, 22696 characters]\"}, {\"date\": \"2024-05-08T19:55:56.824Z\", \"signature\": \"data:image/png;base64,[encoded data, 22684 characters]\"}]', '2024-05-06T13:15', 'Member_Summary_0006035259001.pdf', '{\"year\": \"2024\", \"client_id\": \"client_009\", \"member_id\": \"0006035259001\", \"member_uploadStatus\": \"success\", \"reason_member_upload\": \"uploaded Member Summary Report\", \"member_assessment_name\": \"Member_Summary_0006035259001.pdf\", \"member_ftp_upload_date\": \"2024-05-31 14:34:31\"}', 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
(1536, NULL, NULL, NULL, '0006036394001', '375178', '', '21881792', 'Shelby', 'Bundrum', '', '{\"DOB\": 35262, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"On Exchange\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Alliant\", \"HBA1C\": \"N\", \"Aligned\": \"N\", \"PCP_NPI\": 1902238769, \"Pcp_Zip\": \"\", \"Program\": \"ACA\", \"PCP_Flag\": \"1\", \"Pcp_City\": \"RINGGOLD\", \"Pcp_Name\": \"Jennifer Gibbs\", \"PCP_Phone\": 7068417700, \"Pcp_State\": \"GA\", \"Member_City\": \"COHUTTA\", \"Office_Name\": \"\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Chatsworth\", \"Member_State\": \"GA\", \"Date_Of_Birth\": \"1996-07-16\", \"Mailing_State\": \"GA\", \"Member_Gender\": \"F\", \"Member_Region\": \"\", \"Pcp_Address_1\": \"7566 NASHVILLE ST\", \"Screening_IHA\": \"No\", \"member_id_two\": 375178, \"Mailing_County\": \"MURRAY\", \"Member_Country\": \"MURRAY\", \"PCP_Fax_Number\": \"\", \"Plan_Term_Date\": \"2024-12-31\", \"Member_Address1\": \"4210 LONG VIEW RD\", \"Member_Address2\": \"\", \"Member_Address3\": \"\", \"Member_Zip_Code\": \"30710\", \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"74 2nd Ave E\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": 30705, \"Member_Last_name\": \"Bundrum\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Shelby\", \"Member_Middle_name\": \"Renee\", \"Plan_Effective_Date\": 45292, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_CurrentGender\": \"\", \"Member_Email_Address\": \"Shelbybundrum@gmail.com\", \"Member_Suspect_Codes\": 21, \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Phone_Number\": 2053629224, \"Member_Identification_Number\": \"0006036394001\", \"Member_Alternate_Phone_Number\": \"\", \"Member_Secondary_Phone_Number\": \"\"}', 'client_009', '2024', '', '{\"hraStatus\":18,\"subStatus\":\"\",\"cancelStatus\":0,\"cancelText\":\"\"}', 1, b'1', b'1', '{\"date\": \"07-13-2024 00:00:11\", \"text\": \"Termed\", \"method\": \"auto\", \"status\": 22}', '{\"cron\": \"3\", \"date\": \"2024-07-13 00:00:11\", \"hrastatus\": 18, \"reportstatus\": \"\"}', '{\"LVM\": [], \"utc\": [], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2024-04-25T10:09\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-05-03T12:28\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-05-31T17:29\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-07-11T13:43\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [{\"date\": \"2024-06-11T12:48\", \"text\": \"Scheduled\", \"method\": \"api\", \"status\": 0}], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [{\"date\": \"2024-06-24T12:20\", \"text\": \"Cancellation\", \"method\": \"api\", \"status\": 18}], \"disconnected\": [], \"virtualNoShow\": [{\"date\": \"2024-06-21T16:54\", \"text\": \"Virtual No Show\", \"method\": \"api\", \"status\": 23}], \"callBackRequested\": [], \"callerDisconnected\": []}', '[{\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": \"\", \"hraStatus_date\": \"\", \"reportStatus_date\": \"2024-04-25T10:09\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-05-03T12:28\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-05-31T17:29\"}, {\"text\": \"Scheduled\", \"type\": \"ReportStatus\", \"status\": 0, \"hraStatus\": 1, \"hraStatus_date\": \"2024-06-11T12:48\", \"reportStatus_date\": \"2024-06-11T12:48\"}, {\"text\": \"Cancellation\", \"type\": \"ReportStatus\", \"status\": 18, \"hraStatus\": 3, \"hraStatus_date\": \"2024-06-24T12:20\", \"reportStatus_date\": \"2024-06-24T12:20\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-07-11T13:43\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [{\"date\": \"2024-06-21T16:54\", \"username\": \"NCox\"}], \"hospice\": [], \"deceased\": [], \"completed\": [], \"scheduled\": [{\"date\": \"2024-06-11T12:48\", \"username\": null}, {\"date\": \"2024-06-11T12:48\", \"username\": null}], \"inProgress\": [], \"qaAssigned\": [], \"readyForQa\": [], \"inEligibile\": [], \"termExpired\": [], \"preScheduled\": [], \"coderAssigned\": [], \"readyForCoder\": [], \"patientRefusal\": [], \"readyForUpload\": [], \"clinicianReviewQa\": [], \"assessmentCalcelled\": [], \"appointmentCancelled\": [{\"date\": \"2024-06-24T12:20\", \"username\": \"PFrey1\"}], \"clinicianReviewCoder\": []}', '{\"history\": [{\"modified\": [{\"date\": \"06-21-2024\", \"time\": \"16:57:30\", \"value\": [{\"add\": \"4210 LONG VIEW RD\", \"age\": 27, \"ano\": \"\", \"cno\": \"\", \"dob\": \"1996-07-16\", \"eno\": \"\", \"lob\": \"On Exchange\", \"pno\": 2053629224, \"zip\": \"30710\", \"add2\": \"\", \"add3\": \"\", \"city\": \"COHUTTA\", \"gend\": 1, \"insh\": \"0006036394001\", \"mzip\": 30705, \"name\": \"Shelby Renee Bundrum\", \"plan\": \"Alliant\", \"pphy\": \"Jennifer Gibbs\", \"ppno\": 7068417700, \"cliId\": \"\", \"email\": \"Shelbybundrum@gmail.com\", \"ename\": \"\", \"madd1\": \"74 2nd Ave E\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Chatsworth\", \"pcpid\": \"\", \"state\": \"GA\", \"mstate\": \"GA\", \"pcpadd\": \"7566 NASHVILLE ST\", \"pcpnpi\": 1902238769, \"pcpzip\": \"\", \"region\": \"\", \"aligned\": \"N\", \"mstatus\": \"\", \"pcpcity\": \"RINGGOLD\", \"pcpname\": \"\", \"program\": \"ACA\", \"pcpfaxno\": \"\", \"pcpstate\": \"GA\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"\", \"currentgend\": \"\", \"pphycomment\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": {\"sub\": [], \"indx\": [[\"No Ethnicity\"]], \"comment\": [[\"\"]]}, \"indx\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"1\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"\", \"\"], \"comment\": [\"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"\", \"\"], \"comment\": [\"\", \"\"]}}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"06-21-2024\", \"time\": \"16:57:30\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"06-21-2024 16:57:30\"}', '{\"utc\": [], \"noShow\": [{\"date\": \"2024-06-21T16:54\", \"type\": \"Virtual\", \"subStaus\": \"\", \"username\": \"NCox\", \"hraStatus\": 19, \"cancelText\": \"\", \"cancelStatus\": \"\"}], \"patientRefusal\": [], \"appointmentCancelled\": [{\"date\": \"2024-06-24T12:20\", \"type\": \"Virtual\", \"subStaus\": \"\", \"username\": \"PFrey1\", \"hraStatus\": 3, \"cancelText\": \"\", \"cancelStatus\": 0}]}', NULL, NULL, '{\"utc\": false, \"result\": 3, \"callLog\": [{\"date\": \"7/11/2024 @ 01:43 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Jasmine Crawford\", \"callbackDate\": \"7/19/2024 @ 01:43 PM\"}, {\"date\": \"6/11/2024 @ 12:48 PM\", \"result\": 0, \"comment\": \"Scheduled virtual HRA w/ Nykya C on 6/21 @ 4:50. Texted link to member\'s phone. Member updated address: 4210 Long View Rd, Cohutta, GA 30710.  \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"\"}, {\"date\": \"5/31/2024 @ 05:29 PM\", \"result\": 3, \"comment\": \"Called to schedule F2F HRA w/ Deborah York\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Lakisha Stewart\", \"callbackDate\": \"6/7/2024 @ 05:29 PM\"}, {\"date\": \"5/3/2024 @ 12:28 PM\", \"result\": 3, \"comment\": \"LEFT A VOICEMAIL - ATTEMPT TO SCHEDULE DEBBIE Y. 5/7 \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"5/9/2024 @ 12:28 PM\"}, {\"date\": \"4/25/2024 @ 10:09 AM\", \"result\": 3, \"comment\": \"LVM\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"4/26/2024 @ 10:08 AM\"}], \"visitType\": {\"type\": \"visitType\", \"memberId\": \"0006036394001\", \"visitType\": \"Virtual\"}, \"clinicianId\": {\"type\": \"assignMember\", \"nurseId\": \"96917241\", \"memberId\": \"0006036394001\"}, \"appointmentDate\": {\"type\": \"scheduleDate\", \"nurseId\": \"96917241\", \"memberId\": \"0006036394001\", \"scheduleDate\": \"2024-6-21T16:50\"}}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"04-25-2024 10:09:00\", \"schedulerId\": \"21881792\", \"schedulerLeadId\": \"21881792\"}, {\"date\": \"06-21-2024 16:54:14\", \"schedulerId\": \"21881792\", \"schedulerLeadId\": \"21881792\"}]}', '{\"date\": \"06-24-2024 12:20:24\", \"status\": 0, \"details\": \"hra status changed\", \"disabled\": false, \"notification\": null}', '{\"attemptCount\": 5}', '{\"orderType\": 0, \"sortOrder\": 1721372265}', 1, NULL, NULL, 'Virtual', NULL, '2024-07-01', NULL, NULL, NULL, NULL, NULL, '123456789', '21-04-2024 05:59:32', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(1537, NULL, NULL, NULL, '0006037433001', '352204', '', '21881792', 'KIMBERLY', 'Kellogg', '', '{\"DOB\": 24935, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"On Exchange\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Alliant\", \"HBA1C\": \"N\", \"Aligned\": \"N\", \"PCP_NPI\": 1306816467, \"Pcp_Zip\": \"\", \"Program\": \"ACA\", \"PCP_Flag\": \"1\", \"Pcp_City\": \"GAINESVILLE\", \"Pcp_Name\": \"Lajos Toth\", \"PCP_Phone\": 7705334770, \"Pcp_State\": \"GA\", \"Member_City\": \"Gainesville\", \"Office_Name\": \"\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Gainesville\", \"Member_State\": \"GA\", \"Date_Of_Birth\": \"1968-04-07\", \"Mailing_State\": \"GA\", \"Member_Gender\": \"F\", \"Member_Region\": \"\", \"Pcp_Address_1\": \"725 JESSE JEWELL PKWY SE STE 300\", \"Screening_IHA\": \"No\", \"member_id_two\": 352204, \"Mailing_County\": \"HALL\", \"Member_Country\": \"HALL\", \"PCP_Fax_Number\": \"\", \"Plan_Term_Date\": \"2024-12-31\", \"Member_Address1\": \"770 Park St\", \"Member_Address2\": \"\", \"Member_Zip_Code\": 305010000, \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"770 Park St\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": 30501, \"Member_Last_name\": \"Kellogg\", \"Medication_Review\": \"N\", \"Member_first_name\": \"KIMBERLY\", \"Plan_Effective_Date\": 45292, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"kim_tomlinsonj47@yahoo.com\", \"Member_Suspect_Codes\": \"19, 21\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Phone_Number\": 5416214747, \"Member_Identification_Number\": \"0006037433001\", \"Member_Alternate_Phone_Number\": \"\", \"Member_Secondary_Phone_Number\": 5416214747}', 'client_009', '2024', '', '{\"hraStatus\":18,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'1', b'1', '{\"date\": \"09-11-2024 00:00:19\", \"text\": \"Termed\", \"method\": \"auto\", \"status\": 22}', '{\"cron\": \"3\", \"date\": \"2024-09-11 00:00:19\", \"hrastatus\": 18, \"reportstatus\": \"\"}', '{\"LVM\": [], \"utc\": [{\"date\": \"2024-07-19T18:41\", \"text\": \"UTC\", \"method\": \"api\", \"status\": 19}], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2024-04-25T17:11\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-05-15T15:32\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-05-29T12:25\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-06-06T18:38\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-06-10T15:29\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-07-19T18:41\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [], \"disconnected\": [], \"virtualNoShow\": [], \"callBackRequested\": [], \"callerDisconnected\": []}', '[{\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": \"\", \"hraStatus_date\": \"\", \"reportStatus_date\": \"2024-04-25T17:11\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-05-15T15:32\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-05-29T12:25\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-06-10T15:29\"}, {\"text\": \"UTC\", \"type\": \"ReportStatus\", \"status\": 19, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-07-19T18:41\"}]', NULL, '{\"history\": [{\"modified\": [{\"date\": \"04-21-2024\", \"time\": \"05:59:33\", \"value\": [{\"add\": \"770 Park St\", \"age\": \"\", \"ano\": \"\", \"cno\": 5416214747, \"dob\": \"1968-04-07\", \"eno\": \"\", \"lob\": \"On Exchange\", \"pno\": 5416214747, \"zip\": 305010000, \"add2\": \"\", \"add3\": \"\", \"city\": \"Gainesville\", \"gend\": 1, \"insh\": \"0006037433001\", \"mzip\": 30501, \"name\": \"KIMBERLY Kellogg\", \"plan\": \"Alliant\", \"pphy\": \"Lajos Toth\", \"ppno\": 7705334770, \"cliId\": \"\", \"email\": \"kim_tomlinsonj47@yahoo.com\", \"ename\": \"\", \"madd1\": \"770 Park St\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Gainesville\", \"pcpid\": \"\", \"state\": \"GA\", \"mstate\": \"GA\", \"pcpadd\": \"725 JESSE JEWELL PKWY SE STE 300\", \"pcpnpi\": 1306816467, \"pcpzip\": \"\", \"region\": \"\", \"aligned\": \"N\", \"mstatus\": \"\", \"pcpcity\": \"GAINESVILLE\", \"pcpname\": \"\", \"program\": \"ACA\", \"pcpfaxno\": \"\", \"pcpstate\": \"GA\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"\", \"currentgend\": \"\", \"pphycomment\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": {\"sub\": [], \"indx\": [[\"No Ethnicity\"]], \"comment\": [[\"\"]]}, \"indx\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"1\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": []}, {\"a\": []}, {\"a\": []}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"05-11-2024\", \"time\": \"03:24:44\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"05-11-2024 03:24:44\"}', NULL, NULL, NULL, '{\"utc\": false, \"result\": 3, \"callLog\": [{\"date\": \"9/9/2024 @ 12:07 PM\", \"result\": 3, \"comment\": \"LEFT A VOICEMAIL-Call attempt to schedule a virtual HRA w/ Debbie York \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Alyia Williams\", \"callbackDate\": \"\"}, {\"date\": \"8/2/2024 @ 01:42 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/19/2024 @ 06:41 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Jasmine Crawford\", \"callbackDate\": \"\"}, {\"date\": \"6/10/2024 @ 03:29 PM\", \"result\": 3, \"comment\": \"LVM F2F VISIT WITH DELISE MV \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Mary Valdez\", \"callbackDate\": \"\"}, {\"date\": \"6/6/2024 @ 06:38 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Moira Roethle\", \"callbackDate\": \"6/20/2024 @ 06:37 PM\"}, {\"date\": \"5/29/2024 @ 12:25 PM\", \"result\": 3, \"comment\": \"LEFT A VOICEMAIL - Call attempt to schedule a F2F HRA.\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"5/30/2024 @ 12:25 PM\"}, {\"date\": \"5/15/2024 @ 03:32 PM\", \"result\": 3, \"comment\": \"LEFT A VOICEMAIL -Call attempt to schedule HRA.\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"5/17/2024 @ 03:32 PM\"}, {\"date\": \"4/25/2024 @ 05:11 PM\", \"result\": 3, \"comment\": \"LS first call attempt 4/24/2024\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Patty Frey\", \"callbackDate\": \"5/10/2024 @ 05:11 PM\"}], \"clinicianId\": \"\", \"appointmentDate\": \"\"}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"05-15-2024 15:32:00\", \"schedulerId\": \"21881792\", \"schedulerLeadId\": \"21881792\"}]}', '{\"date\": \"07-19-2024 18:41:55\", \"status\": 3, \"details\": \"moved to utc\", \"disabled\": true, \"notification\": null}', '{\"attemptCount\": 8}', NULL, 1, NULL, NULL, NULL, NULL, '2024-08-26', NULL, NULL, NULL, NULL, NULL, '123456789', '21-04-2024 05:59:33', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(1538, NULL, NULL, NULL, '0006038616001', '347864', '', '26056802', 'yogesh', 'patel', '', '{\"DOB\": 21229, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"On Exchange\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Alliant\", \"HBA1C\": \"N\", \"Aligned\": \"N\", \"PCP_NPI\": 1407849524, \"Pcp_Zip\": \"\", \"Program\": \"ACA\", \"PCP_Flag\": \"1\", \"Pcp_City\": \"BUFORD\", \"Pcp_Name\": \"DIPAK PATEL\", \"PCP_Phone\": 7709457676, \"Pcp_State\": \"GA\", \"Member_City\": \"Buford\", \"Office_Name\": \"\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Buford\", \"Member_State\": \"GA\", \"Date_Of_Birth\": \"1958-02-13\", \"Mailing_State\": \"GA\", \"Member_Gender\": \"M\", \"Member_Region\": \"\", \"Pcp_Address_1\": \"4745 NELSON BROGDON BLVD STE 200\", \"Screening_IHA\": \"No\", \"member_id_two\": 347864, \"Mailing_County\": \"HALL\", \"Member_Country\": \"HALL\", \"PCP_Fax_Number\": \"\", \"Plan_Term_Date\": \"2024-12-31\", \"Member_Address1\": \"4774 Stone Summit Way\", \"Member_Address2\": \"\", \"Member_Zip_Code\": 305190000, \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"4774 Stone Summit Way\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": 30519, \"Member_Last_name\": \"patel\", \"Medication_Review\": \"N\", \"Member_first_name\": \"yogesh\", \"Plan_Effective_Date\": 45292, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"prashantpharma2@gmail.com\", \"Member_Suspect_Codes\": \"21, 48\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Phone_Number\": 6784886078, \"Member_Identification_Number\": \"0006038616001\", \"Member_Alternate_Phone_Number\": \"\"}', 'client_009', '2024', '', '{\"hraStatus\":18,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'0', b'1', '{\"date\": \"01-01-2025 23:33:06\", \"text\": \"Termed\", \"method\": \"auto\", \"status\": 22}', '{\"cron\": \"3\", \"date\": \"2025-01-01 23:33:06\", \"hrastatus\": 18, \"reportstatus\": \"\"}', '{\"LVM\": [], \"utc\": [{\"date\": \"2024-10-11T16:49\", \"text\": \"UTC\", \"method\": \"api\", \"status\": 19}], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2024-04-26T18:13\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-05-13T09:32\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-10-10T12:01\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-10-11T16:49\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [], \"disconnected\": [], \"virtualNoShow\": [], \"callBackRequested\": [{\"date\": \"2024-06-03T13:02\", \"text\": \"Call Back\", \"method\": \"api\", \"status\": 9}], \"callerDisconnected\": []}', '[{\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": \"\", \"hraStatus_date\": \"\", \"reportStatus_date\": \"2024-04-26T18:13\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-05-13T09:32\"}, {\"text\": \"Call Back\", \"type\": \"ReportStatus\", \"status\": 9, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-06-03T13:02\"}, {\"text\": \"UTC\", \"type\": \"ReportStatus\", \"status\": 19, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-10-11T16:49\"}]', '{\"utc\": [{\"date\": \"2024-07-17T13:15\", \"username\": null}], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [], \"scheduled\": [], \"inProgress\": [], \"qaAssigned\": [], \"readyForQa\": [], \"inEligibile\": [], \"termExpired\": [], \"preScheduled\": [], \"coderAssigned\": [], \"readyForCoder\": [], \"patientRefusal\": [], \"readyForUpload\": [], \"clinicianReviewQa\": [], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": []}', '{\"history\": [{\"modified\": [{\"date\": \"04-21-2024\", \"time\": \"05:59:33\", \"value\": [{\"add\": \"4774 Stone Summit Way\", \"age\": \"\", \"ano\": \"\", \"cno\": \"\", \"dob\": \"1958-02-13\", \"eno\": \"\", \"lob\": \"On Exchange\", \"pno\": 6784886078, \"zip\": 305190000, \"add2\": \"\", \"add3\": \"\", \"city\": \"Buford\", \"gend\": 0, \"insh\": \"0006038616001\", \"mzip\": 30519, \"name\": \"yogesh patel\", \"plan\": \"Alliant\", \"pphy\": \"DIPAK PATEL\", \"ppno\": 7709457676, \"cliId\": \"\", \"email\": \"prashantpharma2@gmail.com\", \"ename\": \"\", \"madd1\": \"4774 Stone Summit Way\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Buford\", \"pcpid\": \"\", \"state\": \"GA\", \"mstate\": \"GA\", \"pcpadd\": \"4745 NELSON BROGDON BLVD STE 200\", \"pcpnpi\": 1407849524, \"pcpzip\": \"\", \"region\": \"\", \"aligned\": \"N\", \"mstatus\": \"\", \"pcpcity\": \"BUFORD\", \"pcpname\": \"\", \"program\": \"ACA\", \"pcpfaxno\": \"\", \"pcpstate\": \"GA\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"\", \"currentgend\": \"\", \"pphycomment\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": {\"sub\": [], \"indx\": [[\"No Ethnicity\"]], \"comment\": [[\"\"]]}, \"indx\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"1\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": []}, {\"a\": []}, {\"a\": []}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"05-11-2024\", \"time\": \"03:24:44\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"05-11-2024 03:24:44\"}', NULL, NULL, NULL, '{\"utc\": false, \"result\": 3, \"callLog\": [{\"date\": \"10/28/2024 @ 04:55 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"\"}, {\"date\": \"10/11/2024 @ 04:49 PM\", \"result\": 3, \"comment\": \"Call attempt to schedule an HRA - LVM \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"\"}, {\"date\": \"10/10/2024 @ 12:01 PM\", \"result\": 3, \"comment\": \"Call attempt to schedule an HRA - LVM \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"10/11/2024 @ 12:01 PM\"}, {\"date\": \"6/3/2024 @ 01:02 PM\", \"result\": 6, \"comment\": \"Called to schedule F2F HRA w/ Delise Adams - spoke w/ members son - stated he will have to speak w/ member prior to scheduling \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Lakisha Stewart\", \"callbackDate\": \"6/10/2024 @ 01:02 PM\"}, {\"date\": \"5/13/2024 @ 09:32 AM\", \"result\": 3, \"comment\": \"LEFT A VOICEMAIL -Call attempt to schedule IHA. \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"5/15/2024 @ 09:32 AM\"}, {\"date\": \"4/26/2024 @ 06:13 PM\", \"result\": 3, \"comment\": \"Called to schedule F2F HRA w/ Sallie Key - LVM\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Lakisha Stewart\", \"callbackDate\": \"5/10/2024 @ 06:13 PM\"}], \"clinicianId\": \"\", \"appointmentDate\": \"\"}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"04-26-2024 18:13:00\", \"schedulerId\": \"26056802\", \"schedulerLeadId\": \"26056802\"}]}', '{\"date\": \"10-11-2024 16:49:07\", \"status\": 3, \"details\": \"moved to utc\", \"disabled\": true, \"notification\": null}', '{\"attemptCount\": 6}', NULL, 1, NULL, NULL, NULL, NULL, '2024-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '21-04-2024 05:59:33', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(1539, NULL, NULL, NULL, '0006042106002', '355821', '', NULL, 'Vaishalibahen', 'Patel', '', '{\"DOB\": 27144, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"On Exchange\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Alliant\", \"HBA1C\": \"N\", \"Aligned\": \"N\", \"PCP_NPI\": 1699724419, \"Pcp_Zip\": \"\", \"Program\": \"ACA\", \"PCP_Flag\": \"1\", \"Pcp_City\": \"CUMMING\", \"Pcp_Name\": \"DHAVAL SHAH\", \"PCP_Phone\": 4044804200, \"Pcp_State\": \"GA\", \"Member_City\": \"Dawsonville\", \"Office_Name\": \"\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Dawsonville\", \"Member_State\": \"GA\", \"Date_Of_Birth\": \"1974-04-25\", \"Mailing_State\": \"GA\", \"Member_Gender\": \"F\", \"Member_Region\": \"\", \"Pcp_Address_1\": \"3030 OLD ATLANTA RD STE 500\", \"Screening_IHA\": \"No\", \"member_id_two\": 355821, \"Mailing_County\": \"DAWSON\", \"Member_Country\": \"DAWSON\", \"PCP_Fax_Number\": \"\", \"Plan_Term_Date\": \"2024-12-31\", \"Member_Address1\": \"215 Riley Circle\", \"Member_Address2\": \"\", \"Member_Zip_Code\": 305340000, \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"215 Riley Circle\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": 30534, \"Member_Last_name\": \"Patel\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Vaishalibahen\", \"Plan_Effective_Date\": 45292, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"\", \"Member_Suspect_Codes\": 21, \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Phone_Number\": \"\", \"Member_Identification_Number\": \"0006042106002\", \"Member_Alternate_Phone_Number\": \"\"}', 'client_009', '2024', '', '{\"hraStatus\":18,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'0', b'0', '{\"date\": \"01-01-2025 23:33:06\", \"text\": \"Termed\", \"method\": \"auto\", \"status\": 22}', '{\"cron\": \"3\", \"date\": \"2025-01-01 23:33:06\", \"hrastatus\": 18, \"reportstatus\": \"\"}', NULL, NULL, NULL, '{\"history\": [{\"modified\": [{\"date\": \"04-21-2024\", \"time\": \"05:59:33\", \"value\": [{\"add\": \"215 Riley Circle\", \"age\": \"\", \"ano\": \"\", \"cno\": \"\", \"dob\": \"1974-04-25\", \"eno\": \"\", \"lob\": \"On Exchange\", \"pno\": \"\", \"zip\": 305340000, \"add2\": \"\", \"add3\": \"\", \"city\": \"Dawsonville\", \"gend\": 1, \"insh\": \"0006042106002\", \"mzip\": 30534, \"name\": \"Vaishalibahen Patel\", \"plan\": \"Alliant\", \"pphy\": \"DHAVAL SHAH\", \"ppno\": 4044804200, \"cliId\": \"\", \"email\": \"\", \"ename\": \"\", \"madd1\": \"215 Riley Circle\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Dawsonville\", \"pcpid\": \"\", \"state\": \"GA\", \"mstate\": \"GA\", \"pcpadd\": \"3030 OLD ATLANTA RD STE 500\", \"pcpnpi\": 1699724419, \"pcpzip\": \"\", \"region\": \"\", \"aligned\": \"N\", \"mstatus\": \"\", \"pcpcity\": \"CUMMING\", \"pcpname\": \"\", \"program\": \"ACA\", \"pcpfaxno\": \"\", \"pcpstate\": \"GA\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"\", \"currentgend\": \"\", \"pphycomment\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": {\"sub\": [], \"indx\": [[\"No Ethnicity\"]], \"comment\": [[\"\"]]}, \"indx\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"1\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": []}, {\"a\": []}, {\"a\": []}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"05-11-2024\", \"time\": \"03:24:44\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"05-11-2024 03:24:44\"}', NULL, NULL, NULL, NULL, NULL, '{\"date\": \"04-22-2024 00:31:20\", \"status\": 0, \"details\": \"previous year member 10 months exceeded\", \"disabled\": false, \"notification\": null}', NULL, NULL, 1, NULL, NULL, NULL, NULL, '2024-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '21-04-2024 05:59:33', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(1540, NULL, NULL, NULL, '0006046311001', '357958', '', '2661185', 'DANNY', 'GRANADO', '', '{\"DOB\": 28768, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"On Exchange\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Alliant\", \"HBA1C\": \"N\", \"Aligned\": \"N\", \"PCP_NPI\": 1932170461, \"Pcp_Zip\": \"\", \"Program\": \"ACA\", \"PCP_Flag\": \"1\", \"Pcp_City\": \"AMERICUS\", \"Pcp_Name\": \"BENNIE LAW\", \"PCP_Phone\": 2299375321, \"Pcp_State\": \"GA\", \"Member_City\": \"Ellaville\", \"Office_Name\": \"\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Ellaville\", \"Member_State\": \"GA\", \"Date_Of_Birth\": \"1978-10-05\", \"Mailing_State\": \"GA\", \"Member_Gender\": \"M\", \"Member_Region\": \"\", \"Pcp_Address_1\": \"122 US HIGHWAY 280 W STE A\", \"Screening_IHA\": \"No\", \"member_id_two\": 357958, \"Mailing_County\": \"SCHLEY\", \"Member_Country\": \"SCHLEY\", \"PCP_Fax_Number\": \"\", \"Plan_Term_Date\": \"2024-12-31\", \"Member_Address1\": \"390 E Oglethorpe St\", \"Member_Address2\": \"\", \"Member_Zip_Code\": 31806, \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"390 E Oglethorpe St\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": 31806, \"Member_Ethnicity\": \"White\", \"Member_Last_name\": \"GRANADO\", \"Medication_Review\": \"N\", \"Member_first_name\": \"DANNY\", \"Plan_Effective_Date\": 45292, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"irosales@raineyga.com\", \"Member_Suspect_Codes\": \"120, 145, 150, 21\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Phone_Number\": 2294109092, \"Member_Identification_Number\": \"0006046311001\", \"Member_Alternate_Phone_Number\": \"\"}', 'client_009', '2024', '', '{\"hraStatus\":18,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'1', b'1', '{\"date\": \"01-01-2025 23:33:06\", \"text\": \"Termed\", \"method\": \"auto\", \"status\": 22}', '{\"cron\": \"3\", \"date\": \"2025-01-01 23:33:06\", \"hrastatus\": 18, \"reportstatus\": \"\"}', '{\"LVM\": [], \"utc\": [{\"date\": \"2024-07-16T14:43\", \"text\": \"UTC\", \"method\": \"api\", \"status\": 19}], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2024-05-10T19:01\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-05-30T11:38\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-07-16T14:43\", \"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-17T12:11\", \"text\": \"Call Back\", \"method\": \"api\", \"status\": 9}, {\"date\": \"2024-06-27T19:50\", \"text\": \"Call Back\", \"method\": \"api\", \"status\": 9}, {\"date\": \"2024-07-09T12:31\", \"text\": \"Call Back\", \"method\": \"api\", \"status\": 9}], \"callerDisconnected\": []}', '[{\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": \"\", \"hraStatus_date\": \"\", \"reportStatus_date\": \"2024-05-10T19:01\"}, {\"text\": \"Call Back\", \"type\": \"ReportStatus\", \"status\": 9, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-05-17T12:11\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-05-30T11:38\"}, {\"text\": \"Call Back\", \"type\": \"ReportStatus\", \"status\": 9, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-06-27T19:50\"}, {\"text\": \"Call Back\", \"type\": \"ReportStatus\", \"status\": 9, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-07-09T12:31\"}, {\"text\": \"UTC\", \"type\": \"ReportStatus\", \"status\": 19, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-07-16T14:43\"}]', '{\"utc\": [{\"date\": \"2024-07-17T13:15\", \"username\": null}], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [], \"scheduled\": [], \"inProgress\": [], \"qaAssigned\": [], \"readyForQa\": [], \"inEligibile\": [], \"termExpired\": [], \"preScheduled\": [], \"coderAssigned\": [], \"readyForCoder\": [], \"patientRefusal\": [], \"readyForUpload\": [], \"clinicianReviewQa\": [], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": []}', '{\"history\": [{\"modified\": [{\"date\": \"04-21-2024\", \"time\": \"05:59:34\", \"value\": [{\"add\": \"390 E Oglethorpe St\", \"age\": \"\", \"ano\": \"\", \"cno\": \"\", \"dob\": \"1978-10-05\", \"eno\": \"\", \"lob\": \"On Exchange\", \"pno\": 2294109092, \"zip\": 31806, \"add2\": \"\", \"add3\": \"\", \"city\": \"Ellaville\", \"gend\": 0, \"insh\": \"0006046311001\", \"mzip\": 31806, \"name\": \"DANNY GRANADO\", \"plan\": \"Alliant\", \"pphy\": \"BENNIE LAW\", \"ppno\": 2299375321, \"cliId\": \"\", \"email\": \"irosales@raineyga.com\", \"ename\": \"\", \"madd1\": \"390 E Oglethorpe St\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Ellaville\", \"pcpid\": \"\", \"state\": \"GA\", \"mstate\": \"GA\", \"pcpadd\": \"122 US HIGHWAY 280 W STE A\", \"pcpnpi\": 1932170461, \"pcpzip\": \"\", \"region\": \"\", \"aligned\": \"N\", \"mstatus\": \"\", \"pcpcity\": \"AMERICUS\", \"pcpname\": \"\", \"program\": \"ACA\", \"pcpfaxno\": \"\", \"pcpstate\": \"GA\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"\", \"currentgend\": \"\", \"pphycomment\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": {\"sub\": [], \"indx\": [[\"No Ethnicity\"]], \"comment\": [[\"\"]]}, \"indx\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"1\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": []}, {\"a\": []}, {\"a\": []}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"05-11-2024\", \"time\": \"03:24:44\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"05-11-2024 03:24:44\"}', NULL, NULL, NULL, '{\"utc\": false, \"result\": 3, \"callLog\": [{\"date\": \"10/30/2024 @ 03:08 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"\"}, {\"date\": \"8/20/2024 @ 10:54 AM\", \"result\": 3, \"comment\": \"Call attempt to schedule a virtual HRA w/ Faith Enwefah - LVM \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"\"}, {\"date\": \"7/16/2024 @ 02:43 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Jasmine Crawford\", \"callbackDate\": \"\"}, {\"date\": \"7/9/2024 @ 12:31 PM\", \"result\": 6, \"comment\": \"Called to schedule HRA w/ FAITH ENWEFAH\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Tressa  Scott\", \"callbackDate\": \"7/16/2024 @ 12:31 PM\"}, {\"date\": \"6/27/2024 @ 07:50 PM\", \"result\": 6, \"comment\": \"Call back, Danny not home. -MR\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Moira Roethle\", \"callbackDate\": \"7/4/2024 @ 07:50 PM\"}, {\"date\": \"5/30/2024 @ 11:38 AM\", \"result\": 3, \"comment\": \"LEFT A VOICEMAIL- Call attempt to schedule a virtual HRA.\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"5/31/2024 @ 11:37 AM\"}, {\"date\": \"5/17/2024 @ 12:11 PM\", \"result\": 6, \"comment\": \"Call back, person who answered said the call was going in and out. -MR\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Moira Roethle\", \"callbackDate\": \"5/18/2024 @ 12:11 PM\"}, {\"date\": \"5/10/2024 @ 07:01 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Moira Roethle\", \"callbackDate\": \"5/11/2024 @ 07:01 PM\"}], \"clinicianId\": \"\", \"appointmentDate\": \"\"}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"05-10-2024 19:01:00\", \"schedulerId\": \"2661185\", \"schedulerLeadId\": \"2661185\"}]}', '{\"date\": \"07-16-2024 14:43:46\", \"status\": 3, \"details\": \"moved to utc\", \"disabled\": true, \"notification\": null}', '{\"attemptCount\": 8}', NULL, 1, NULL, NULL, NULL, NULL, '2024-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '21-04-2024 05:59:34', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(1541, NULL, NULL, NULL, '0006049699002', '351797', '', NULL, 'Joseph', 'Holt', '', '{\"DOB\": 28690, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"On Exchange\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Alliant\", \"HBA1C\": \"N\", \"Aligned\": \"N\", \"PCP_NPI\": 1518953785, \"Pcp_Zip\": \"\", \"Program\": \"ACA\", \"PCP_Flag\": \"1\", \"Pcp_City\": \"CHATSWORTH\", \"Pcp_Name\": \"YARA FATTOUH\", \"PCP_Phone\": 7066955500, \"Pcp_State\": \"GA\", \"Member_City\": \"Ranger\", \"Office_Name\": \"\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Ranger\", \"Member_State\": \"GA\", \"Date_Of_Birth\": \"1978-07-19\", \"Mailing_State\": \"GA\", \"Member_Gender\": \"M\", \"Member_Region\": \"\", \"Pcp_Address_1\": \"1111 HIGHWAY 76\", \"Screening_IHA\": \"No\", \"member_id_two\": 351797, \"Mailing_County\": \"Gordon\", \"Member_Country\": \"Gordon\", \"PCP_Fax_Number\": \"\", \"Plan_Term_Date\": \"2024-12-31\", \"Member_Address1\": \"1649 us hwy 411 ne\", \"Member_Address2\": \"\", \"Member_Zip_Code\": 307340000, \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"1649 us hwy 411 ne\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": 30734, \"Member_Last_name\": \"Holt\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Joseph\", \"Plan_Effective_Date\": 45292, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"\", \"Member_Suspect_Codes\": \"146, 160, 20, 21\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Phone_Number\": \"\", \"Member_Identification_Number\": \"0006049699002\", \"Member_Alternate_Phone_Number\": \"\"}', 'client_009', '2024', '', '{\"hraStatus\":18,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'0', b'0', '{\"date\": \"01-01-2025 23:33:07\", \"text\": \"Termed\", \"method\": \"auto\", \"status\": 22}', '{\"cron\": \"3\", \"date\": \"2025-01-01 23:33:07\", \"hrastatus\": 18, \"reportstatus\": \"\"}', NULL, NULL, NULL, '{\"history\": [{\"modified\": [{\"date\": \"04-21-2024\", \"time\": \"05:59:34\", \"value\": [{\"add\": \"1649 us hwy 411 ne\", \"age\": \"\", \"ano\": \"\", \"cno\": \"\", \"dob\": \"1978-07-19\", \"eno\": \"\", \"lob\": \"On Exchange\", \"pno\": \"\", \"zip\": 307340000, \"add2\": \"\", \"add3\": \"\", \"city\": \"Ranger\", \"gend\": 0, \"insh\": \"0006049699002\", \"mzip\": 30734, \"name\": \"Joseph Holt\", \"plan\": \"Alliant\", \"pphy\": \"YARA FATTOUH\", \"ppno\": 7066955500, \"cliId\": \"\", \"email\": \"\", \"ename\": \"\", \"madd1\": \"1649 us hwy 411 ne\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Ranger\", \"pcpid\": \"\", \"state\": \"GA\", \"mstate\": \"GA\", \"pcpadd\": \"1111 HIGHWAY 76\", \"pcpnpi\": 1518953785, \"pcpzip\": \"\", \"region\": \"\", \"aligned\": \"N\", \"mstatus\": \"\", \"pcpcity\": \"CHATSWORTH\", \"pcpname\": \"\", \"program\": \"ACA\", \"pcpfaxno\": \"\", \"pcpstate\": \"GA\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"\", \"currentgend\": \"\", \"pphycomment\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": {\"sub\": [], \"indx\": [[\"No Ethnicity\"]], \"comment\": [[\"\"]]}, \"indx\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"1\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": []}, {\"a\": []}, {\"a\": []}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"05-11-2024\", \"time\": \"03:24:44\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"05-11-2024 03:24:44\"}', NULL, NULL, NULL, NULL, NULL, '{\"date\": \"04-22-2024 00:31:20\", \"status\": 0, \"details\": \"previous year member 10 months exceeded\", \"disabled\": false, \"notification\": null}', NULL, NULL, 1, NULL, NULL, NULL, NULL, '2024-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '21-04-2024 05:59:34', 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
(1542, NULL, NULL, NULL, '0006050325001', '381210', '', '2661185', 'Ricky', 'Miller', '', '{\"DOB\": 22501, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"On Exchange\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Alliant\", \"HBA1C\": \"N\", \"Aligned\": \"N\", \"PCP_NPI\": 1700172848, \"Pcp_Zip\": \"\", \"Program\": \"ACA\", \"PCP_Flag\": \"1\", \"Pcp_City\": \"AUGUSTA\", \"Pcp_Name\": \"HAJRA HASAN\", \"PCP_Phone\": 7065485833, \"Pcp_State\": \"GA\", \"Member_City\": \"Martinez\", \"Office_Name\": \"\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Martinez\", \"Member_State\": \"GA\", \"Date_Of_Birth\": \"1961-08-08\", \"Mailing_State\": \"GA\", \"Member_Gender\": \"M\", \"Member_Region\": \"\", \"Pcp_Address_1\": \"1701 MAGNOLIA WAY\", \"Screening_IHA\": \"No\", \"member_id_two\": 381210, \"Mailing_County\": \"COLUMBIA\", \"Member_Country\": \"COLUMBIA\", \"PCP_Fax_Number\": \"\", \"Plan_Term_Date\": \"2024-12-31\", \"Member_Address1\": \"3953 Foxhill Ct\", \"Member_Address2\": \"\", \"Member_Zip_Code\": 30907, \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"3953 Foxhill Ct\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": 30907, \"Member_Last_name\": \"Miller\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Ricky\", \"Plan_Effective_Date\": 45292, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_Email_Address\": \"tnftvol@aol.com\", \"Member_Suspect_Codes\": 21, \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Member_Primary_Phone_Number\": 7068338868, \"Member_Identification_Number\": \"0006050325001\", \"Member_Alternate_Phone_Number\": \"\"}', 'client_009', '2024', '', '{\"hraStatus\":18,\"subStatus\":\"\",\"cancelStatus\":\"\",\"cancelText\":\"\"}', 1, b'1', b'1', '{\"date\": \"01-01-2025 23:33:07\", \"text\": \"Termed\", \"method\": \"auto\", \"status\": 22}', '{\"cron\": \"3\", \"date\": \"2025-01-01 23:33:07\", \"hrastatus\": 18, \"reportstatus\": \"\"}', '{\"LVM\": [], \"utc\": [{\"date\": \"2024-07-02T18:24\", \"text\": \"UTC\", \"method\": \"api\", \"status\": 19}], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2024-05-10T19:03\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-05-17T12:13\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-05-20T16:41\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-06-27T19:51\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}, {\"date\": \"2024-07-02T18:24\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [], \"inEligible\": [], \"unschedule\": [], \"f2fCallBack\": [], \"mailboxFull\": [], \"rescheduled\": [], \"wrongNumber\": [], \"cancellation\": [], \"disconnected\": [], \"virtualNoShow\": [], \"callBackRequested\": [], \"callerDisconnected\": []}', '[{\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": \"\", \"hraStatus_date\": \"\", \"reportStatus_date\": \"2024-05-10T19:03\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-05-20T16:41\"}, {\"text\": \"Pending\", \"type\": \"ReportStatus\", \"status\": 21, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-06-27T19:51\"}, {\"text\": \"UTC\", \"type\": \"ReportStatus\", \"status\": 19, \"hraStatus\": null, \"hraStatus_date\": null, \"reportStatus_date\": \"2024-07-02T18:24\"}]', NULL, '{\"history\": [{\"modified\": [{\"date\": \"04-21-2024\", \"time\": \"05:59:34\", \"value\": [{\"add\": \"3953 Foxhill Ct\", \"age\": \"\", \"ano\": \"\", \"cno\": \"\", \"dob\": \"1961-08-08\", \"eno\": \"\", \"lob\": \"On Exchange\", \"pno\": 7068338868, \"zip\": 30907, \"add2\": \"\", \"add3\": \"\", \"city\": \"Martinez\", \"gend\": 0, \"insh\": \"0006050325001\", \"mzip\": 30907, \"name\": \"Ricky Miller\", \"plan\": \"Alliant\", \"pphy\": \"HAJRA HASAN\", \"ppno\": 7065485833, \"cliId\": \"\", \"email\": \"tnftvol@aol.com\", \"ename\": \"\", \"madd1\": \"3953 Foxhill Ct\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Martinez\", \"pcpid\": \"\", \"state\": \"GA\", \"mstate\": \"GA\", \"pcpadd\": \"1701 MAGNOLIA WAY\", \"pcpnpi\": 1700172848, \"pcpzip\": \"\", \"region\": \"\", \"aligned\": \"N\", \"mstatus\": \"\", \"pcpcity\": \"AUGUSTA\", \"pcpname\": \"\", \"program\": \"ACA\", \"pcpfaxno\": \"\", \"pcpstate\": \"GA\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"\", \"currentgend\": \"\", \"pphycomment\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": {\"sub\": [], \"indx\": [[\"No Ethnicity\"]], \"comment\": [[\"\"]]}, \"indx\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"1\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": []}, {\"a\": []}, {\"a\": []}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"05-11-2024\", \"time\": \"03:24:44\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"05-11-2024 03:24:44\"}', NULL, NULL, NULL, '{\"utc\": false, \"result\": 3, \"callLog\": [{\"date\": \"11/6/2024 @ 02:02 PM\", \"result\": 13, \"comment\": \"\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Rebecca Mangold\", \"callbackDate\": \"\"}, {\"date\": \"11/1/2024 @ 01:23 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 2, \"scheduler\": \"Auto Dialer\", \"callbackDate\": \"\"}, {\"date\": \"9/9/2024 @ 03:05 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Mariana Bernard\", \"callbackDate\": \"\"}, {\"date\": \"8/20/2024 @ 10:57 AM\", \"result\": 3, \"comment\": \"Call attempt to schedule a virtual HRA w/ Faith Enwefah - LVM \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"\"}, {\"date\": \"7/16/2024 @ 07:12 PM\", \"result\": 3, \"comment\": \"07/16/2024 JC: called for HRA-Connie Middleton-Virtual: LVM  \", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Julisa Copeland\", \"callbackDate\": \"\"}, {\"date\": \"7/2/2024 @ 06:24 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Tressa  Scott\", \"callbackDate\": \"\"}, {\"date\": \"6/27/2024 @ 07:51 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Moira Roethle\", \"callbackDate\": \"7/4/2024 @ 07:51 PM\"}, {\"date\": \"5/20/2024 @ 04:41 PM\", \"result\": 3, \"comment\": \"LEFT A VOICEMAIL-Call attempt to schedule a virtual HRA.\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"5/23/2024 @ 04:40 PM\"}, {\"date\": \"5/17/2024 @ 12:13 PM\", \"result\": 3, \"comment\": \"Called to schedule Virtual HRA w/ Faith Enwefah - LVM\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Lakisha Stewart\", \"callbackDate\": \"5/24/2024 @ 12:13 PM\"}, {\"date\": \"5/10/2024 @ 07:03 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Moira Roethle\", \"callbackDate\": \"5/13/2024 @ 07:03 PM\"}], \"clinicianId\": \"\", \"appointmentDate\": \"\"}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"05-10-2024 19:03:00\", \"schedulerId\": \"2661185\", \"schedulerLeadId\": \"2661185\"}]}', '{\"date\": \"07-02-2024 18:24:03\", \"status\": 3, \"details\": \"moved to utc\", \"disabled\": true, \"notification\": null}', '{\"attemptCount\": 10}', NULL, 1, NULL, NULL, NULL, NULL, '2024-12-31', NULL, NULL, NULL, NULL, NULL, '123456789', '21-04-2024 05:59:34', 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
(1543, 2888643, 44829497, '56716210', '0006056036001', '356648', '', '26056802', 'Luis', 'Roman', '', '{\"DOB\": 28381, \"KED\": \"N\", \"LDL\": \"N\", \"LOB\": \"On Exchange\", \"PAD\": \"N\", \"DEXA\": \"N\", \"FOBT\": \"N\", \"Plan\": \"Alliant\", \"HBA1C\": \"N\", \"Notes\": \"Fax Not Sent\", \"Aligned\": \"N\", \"PCP_NPI\": 1538161252, \"Pcp_Zip\": \"30518\", \"Program\": \"ACA\", \"PCP_Flag\": \"1\", \"Pcp_City\": \"SUGAR HILL\", \"Pcp_Name\": \"Dr. Christopher Borrego\", \"PCP_Phone\": 7709451990, \"Pcp_State\": \"GA\", \"Member_City\": \"Gainesville\", \"Office_Name\": \"\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Gainesville\", \"Member_State\": \"GA\", \"Date_Of_Birth\": \"1977-09-13\", \"Mailing_State\": \"GA\", \"Member_Gender\": \"M\", \"Member_Region\": \"\", \"Pcp_Address_1\": \"4720 NELSON BROGDON BLVD\", \"Screening_IHA\": \"No\", \"member_id_two\": 356648, \"Mailing_County\": \"HALL\", \"Member_Country\": \"HALL\", \"PCP_Fax_Number\": \"7709453631\", \"Plan_Term_Date\": \"2024-12-31\", \"Member_Address1\": \"4102 Box Elder Path\", \"Member_Address2\": \"\", \"Member_Zip_Code\": 305040000, \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"4102 Box Elder Path\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": 30504, \"Member_Last_name\": \"Roman\", \"Medication_Review\": \"N\", \"Member_first_name\": \"Luis\", \"Plan_Effective_Date\": 45292, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_CurrentGender\": \"Male\", \"Member_Email_Address\": \"luisroman26@hotmail.com\", \"Member_Suspect_Codes\": \"20, 21\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Successful_Reaching_PCP\": \"No\", \"Member_Primary_Phone_Number\": 6782660984, \"Member_Identification_Number\": \"0006056036001\", \"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:34:37\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}', '{\"date\": \"2024-05-31 14:34:37\", \"hrastatus\": \"\", \"reportstatus\": \"Completed\"}', '{\"LVM\": [], \"utc\": [], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [{\"date\": \"2024-05-08T20:14\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2024-05-10T10:54\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2024-05-10T11:42\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2024-05-31T14:34\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [{\"date\": \"2024-04-25T17:05\", \"text\": \"Scheduled\", \"method\": \"api\", \"status\": 0}, {\"date\": \"2024-04-30T17:55\", \"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-04-25T17:05\", \"reportStatus_date\": \"2024-04-25T17:05\"}, {\"text\": \"Scheduled\", \"type\": \"HraStatus\", \"status\": 0, \"hraStatus\": 2, \"hraStatus_date\": \"2024-05-05T16:54\", \"reportStatus_date\": \"2024-04-30T17:55\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 10, \"hraStatus_date\": \"2024-05-10T11:42\", \"reportStatus_date\": \"2024-05-10T11:42\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 11, \"hraStatus_date\": \"2024-05-31T14:34\", \"reportStatus_date\": \"2024-05-31T14:34\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [{\"date\": \"2024-05-31T14:34\", \"username\": null}], \"scheduled\": [{\"date\": \"2024-04-25T17:05\", \"username\": null}, {\"date\": \"2024-04-25T17:05\", \"username\": null}, {\"date\": \"2024-04-30T17:55\", \"username\": null}], \"inProgress\": [{\"date\": \"2024-05-05T16:54\", \"username\": \"DAdams\"}], \"qaAssigned\": [{\"date\": \"2024-05-09T08:06\", \"username\": \"JScanlonQAL\"}], \"readyForQa\": [{\"date\": \"2024-05-08T20:14\", \"username\": \"JessicaSAdmin\"}, {\"date\": \"2024-05-09T19:22\", \"username\": \"DAdams\"}], \"inEligibile\": [], \"termExpired\": [], \"preScheduled\": [], \"coderAssigned\": [{\"date\": \"2024-05-10T11:42\", \"username\": \"JWren1\"}], \"readyForCoder\": [{\"date\": \"2024-05-10T10:54\", \"username\": \"JScanlonQAL\"}], \"patientRefusal\": [], \"readyForUpload\": [{\"date\": \"2024-05-10T11:42\", \"username\": \"JWren1\"}], \"clinicianReviewQa\": [{\"date\": \"2024-05-09T13:17\", \"username\": \"JScanlonQAL\"}], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": []}', '{\"history\": [{\"modified\": [{\"date\": \"07-01-2024\", \"time\": \"11:04:59\", \"value\": [{\"add\": \"4102 Box Elder Path\", \"age\": 46, \"ano\": \"\", \"cno\": \"\", \"dob\": \"1977-09-13\", \"eno\": \"9735255180\", \"lob\": \"On Exchange\", \"pno\": 6782660984, \"zip\": 305040000, \"add2\": \"\", \"add3\": \"\", \"city\": \"Gainesville\", \"gend\": 0, \"insh\": \"0006056036001\", \"mzip\": 30504, \"name\": \"Luis Roman\", \"plan\": \"Alliant\", \"pphy\": \"Dr. Christopher Borrego\", \"ppno\": 7709451990, \"race\": \"\", \"cliId\": \"\", \"email\": \"luisroman26@hotmail.com\", \"ename\": \"Doris Hernandez\", \"madd1\": \"4102 Box Elder Path\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Gainesville\", \"pcpid\": \"\", \"state\": \"GA\", \"mstate\": \"GA\", \"pcpadd\": \"4720 NELSON BROGDON BLVD\", \"pcpnpi\": \"\", \"pcpzip\": \"30518\", \"region\": \"\", \"aligned\": \"N\", \"mstatus\": \"Married\", \"pcpcity\": \"SUGAR HILL\", \"pcpname\": \"\", \"program\": \"ACA\", \"evalDate\": \"2024-5-7 08:00 AM\", \"evalName\": \"Delise Adams, FNP\", \"pcpfaxno\": \"7709453631\", \"pcpstate\": \"GA\", \"uniqueid\": \"\", \"pcpcounty\": \"\", \"medicaidid\": \"\", \"medicareid\": \"\", \"currentgend\": \"Male\", \"pphycomment\": \"\", \"primaryLanguage\": \"\", \"currentgendcomment\": \"\"}, {\"a\": {\"sub\": [], \"indx\": [\"\", \"\", \"\", \"1\", \"\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\", \"\", \"\", \"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\", \"\", \"\"], \"comment\": [\"\", \"\", \"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"1\", \"\"], \"comment\": [\"\", \"\"]}}, {\"a\": {\"sub\": [], \"indx\": [\"\", \"1\"], \"comment\": [\"\", \"\"]}}], \"status\": true, \"component\": \"demographic\"}, {\"date\": \"05-11-2024\", \"time\": \"03:24:44\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"07-01-2024 11:04:59\"}', NULL, NULL, '{\"memberId\": \"0006056036001\", \"clinician\": \"Delise Adams\", \"qaAnalyst\": \"JScanlon Scanlon\", \"queryData\": [{\"date\": \"Thu, 09 May 2024 17:17:48 GMT\", \"name\": \"JScanlon \", \"role\": \"qa_lead\", \"files\": [], \"query\": {\"feedback\": \"HI Delise,\\n1. In the medication section,  compliance questions\\\"no\\\" was selected regarding medication affordability. Did he have \\nconcerns paying for his medication? If so we can add to the CM referral. Or,If that was in error, please update\\n2. He is taking Vitamin D and a deficiency is listed in the PAT form and PDC. Please add to the assessment of dx if this is ongoing.\\n3. In the vital signs, can you please fix the reading for pulse ox? there are extra numbers.\\nthank you,\\nJessica\", \"response\": \"\"}, \"mailId\": \"\"}, {\"date\": \"Thu, 09 May 2024 23:22:39 GMT\", \"name\": \"Delise \", \"role\": \"nurse\", \"files\": [], \"query\": {\"feedback\": \"\", \"response\": \"1. Was done in error. \\nOther corrections made.\\n\\nThank you. \"}, \"mailId\": \"\"}], \"memberName\": \"Luis Roman\", \"codingAnalyst\": \"\", \"dateOfService\": \"05/07/2024 08:00AM\", \"clinicianMailId\": \"deliseadams@sbcglobal.net\", \"qaAnalystMailId\": \"j.scalon@focuscares.com\", \"codingAnalystMailId\": \"\"}', '{\"utc\": false, \"result\": 0, \"callLog\": [{\"date\": \"4/25/2024 @ 05:05 PM\", \"result\": 0, \"comment\": \"Scheduled F2F HRA w/ Delise Adams on 5/7 @ 9am \", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Lakisha Stewart\", \"callbackDate\": \"\"}], \"visitType\": {\"type\": \"visitType\", \"memberId\": \"0006056036001\", \"visitType\": \"In Person\"}, \"clinicianId\": {\"type\": \"assignMember\", \"nurseId\": \"56716210\", \"memberId\": \"0006056036001\"}, \"appointmentDate\": {\"type\": \"scheduleDate\", \"nurseId\": \"56716210\", \"memberId\": \"0006056036001\", \"scheduleDate\": \"2024-5-7T09:00\"}}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"04-25-2024 17:05:00\", \"schedulerId\": \"26056802\", \"schedulerLeadId\": \"26056802\"}]}', '{\"date\": \"04-30-2024 17:55:49\", \"status\": 1, \"details\": \"scheduled directly\", \"disabled\": false, \"notification\": null}', '{\"attemptCount\": 1}', NULL, 0, NULL, '[{\"date\": \"2024-05-31 14:34:35\", \"status\": 0, \"message\": \"Fax sent failed\", \"fax_response\": \"{\\\"transaction_id\\\":\\\"6e0df9d6-1f7c-11ef-9ba6-f923acde71a9\\\",\\\"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-7T08:00', '2024-04-30', NULL, NULL, NULL, NULL, NULL, '123456789', '21-04-2024 05:59:34', NULL, NULL, NULL, NULL, '{\"year\": \"2024\", \"client_id\": \"client_009\", \"member_id\": \"0006056036001\", \"reason_hra\": \"uploaded for HRA Assessment\", \"reason_summary\": \"uploaded for Summary Assessment\", \"assessment_name\": \"ACA_0006056036001_Roman, Luis_05072024.pdf\", \"ftp_upload_date\": \"2024-05-31 14:34:35\", \"hra_uploadStatus\": \"success\", \"summary_uploadStats\": \"success\", \"summary_assessment_name\": \"PCP_Borrego, Christopher_0006056036001_05072024.pdf\"}', 'ACA_0006056036001_Roman, Luis_05072024', NULL, 'PCP_Borrego, Christopher_0006056036001_05072024', NULL, '[{\"date\": \"2024-05-08T08:47:22.036Z\", \"signature\": \"data:image/png;base64,[encoded data, 23484 characters]\"}, {\"date\": \"2024-05-09T23:22:38.981Z\", \"signature\": \"data:image/png;base64,[encoded data, 23464 characters]\"}]', '2024-05-07T08:45', 'Member_Summary_0006056036001.pdf', '{\"year\": \"2024\", \"client_id\": \"client_009\", \"member_id\": \"0006056036001\", \"member_uploadStatus\": \"success\", \"reason_member_upload\": \"uploaded Member Summary Report\", \"member_assessment_name\": \"Member_Summary_0006056036001.pdf\", \"member_ftp_upload_date\": \"2024-05-31 14:34:36\"}', 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
(1544, 57818338, 44829497, '62685179', '0006056835001', '389000', '', '2661185', 'MONICA', 'FURSE', '', '{\"DOB\": 27488, \"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. Meredith \", \"PCP_Phone\": \"\", \"Member_City\": \"Augusta\", \"Office_Name\": \"\", \"MICROALBUMIN\": \"N\", \"Mailing_City\": \"Augusta\", \"Member_State\": \"GA\", \"Date_Of_Birth\": \"1975-04-04\", \"Mailing_State\": \"GA\", \"Member_Gender\": \"F\", \"Member_Region\": \"\", \"Pcp_Address_1\": \"\", \"Screening_IHA\": \"No\", \"member_id_two\": 389000, \"Mailing_County\": \"RICHMOND\", \"Member_Country\": \"RICHMOND\", \"PCP_Fax_Number\": \"\", \"Plan_Term_Date\": \"2024-12-31\", \"Member_Address1\": \"706 Hall St\", \"Member_Address2\": \"\", \"Member_Zip_Code\": 30901, \"Pain_Assessment\": \"N\", \"Mailing_Address1\": \"706 Hall St\", \"Mailing_Address2\": \"\", \"Mailing_Zip_Code\": 30901, \"Member_Last_name\": \"FURSE\", \"Medication_Review\": \"N\", \"Member_first_name\": \"MONICA\", \"Plan_Effective_Date\": 45292, \"DIGITAL_RETINAL_EXAM\": \"N\", \"Member_CurrentGender\": \"Female\", \"Member_Email_Address\": \"MONICA.FURSE@GMAIL.COM\", \"Member_Suspect_Codes\": \"161.2, 21\", \"Functional_Assessment\": \"N\", \"Dual_Eligibility_Status\": \"N\", \"Successful_Reaching_PCP\": \"No\", \"Member_Primary_Phone_Number\": 7063062380, \"Member_Identification_Number\": \"0006056835001\", \"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:34:43\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}', '{\"date\": \"2024-05-31 14:34:43\", \"hrastatus\": \"\", \"reportstatus\": \"Completed\"}', '{\"LVM\": [], \"utc\": [], \"other\": [], \"termed\": [], \"deadAir\": [], \"hospice\": [], \"pending\": [{\"date\": \"2024-05-10T19:05\", \"text\": \"Pending\", \"method\": \"api\", \"status\": 21}], \"refusal\": [], \"deceased\": [], \"lineBusy\": [], \"completed\": [{\"date\": \"2024-05-22T14:31\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2024-05-28T10:06\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2024-05-28T12:28\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}, {\"date\": \"2024-05-31T14:34\", \"text\": \"Completed\", \"method\": \"api\", \"status\": 20}], \"f2fNoShow\": [], \"noAnsnwer\": [], \"noVmSetup\": [], \"scheduled\": [{\"date\": \"2024-05-17T12:21\", \"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-05-10T19:05\"}, {\"text\": \"Scheduled\", \"type\": \"HraStatus\", \"status\": 0, \"hraStatus\": 6, \"hraStatus_date\": \"2024-05-20T15:49\", \"reportStatus_date\": \"2024-05-17T12:21\"}, {\"text\": \"Completed\", \"type\": \"HraStatus\", \"status\": 20, \"hraStatus\": 6, \"hraStatus_date\": \"2024-05-25T10:52\", \"reportStatus_date\": \"2024-05-22T14:31\"}, {\"text\": \"Completed\", \"type\": \"ReportStatus\", \"status\": 20, \"hraStatus\": 11, \"hraStatus_date\": \"2024-05-31T14:34\", \"reportStatus_date\": \"2024-05-31T14:34\"}]', '{\"utc\": [], \"other\": [], \"noShow\": [], \"hospice\": [], \"deceased\": [], \"completed\": [{\"date\": \"2024-05-31T14:34\", \"username\": null}], \"scheduled\": [{\"date\": \"2024-05-17T12:21\", \"username\": null}, {\"date\": \"2024-05-17T12:21\", \"username\": null}], \"inProgress\": [{\"date\": \"2024-05-20T15:40\", \"username\": \"FEnwefah\"}], \"qaAssigned\": [{\"date\": \"2024-05-22T14:32\", \"username\": \"JScanlonQAL\"}], \"readyForQa\": [{\"date\": \"2024-05-20T15:43\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-20T15:46\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-20T15:49\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-22T12:52\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-22T12:55\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-22T12:58\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-22T13:02\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-22T13:04\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-22T13:07\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-22T13:10\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-22T13:12\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-22T13:13\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-22T13:16\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-22T13:17\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-22T13:19\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-22T13:22\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-22T13:25\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-22T13:28\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-22T13:31\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-22T13:34\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-22T13:37\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-22T13:40\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-22T13:43\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-22T13:46\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-22T13:49\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-22T13:52\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-22T13:55\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-22T13:56\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-22T13:56\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-22T14:03\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-22T14:06\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-22T14:09\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-22T14:12\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-22T14:15\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-22T14:18\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-22T14:21\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-22T14:24\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-22T14:25\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-22T14:25\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-22T14:28\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-22T14:29\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-22T14:30\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-22T14:31\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-22T14:31\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-22T14:31\", \"username\": \"FEnwefah\"}, {\"date\": \"2024-05-25T10:52\", \"username\": \"FEnwefah\"}], \"inEligibile\": [], \"termExpired\": [], \"preScheduled\": [], \"coderAssigned\": [{\"date\": \"2024-05-28T12:28\", \"username\": \"JWren1\"}], \"readyForCoder\": [{\"date\": \"2024-05-28T10:06\", \"username\": \"JSilverio\"}], \"patientRefusal\": [], \"readyForUpload\": [{\"date\": \"2024-05-28T12:28\", \"username\": \"JWren1\"}], \"clinicianReviewQa\": [{\"date\": \"2024-05-24T16:36\", \"username\": \"JSilverio\"}], \"assessmentCalcelled\": [], \"appointmentCancelled\": [], \"clinicianReviewCoder\": []}', '{\"history\": [{\"modified\": [{\"date\": \"05-25-2024\", \"time\": \"10:52:10\", \"value\": [{\"add\": \"706 Hall St\", \"age\": 49, \"ano\": \"\", \"cno\": \"\", \"dob\": \"1975-04-04\", \"eno\": \"762 328 8320\", \"lob\": \"On Exchange\", \"pno\": 7063062380, \"zip\": 30901, \"add2\": \"\", \"add3\": \"\", \"city\": \"Augusta\", \"gend\": 1, \"insh\": \"0006056835001\", \"mzip\": 30901, \"name\": \"MONICA FURSE\", \"plan\": \"Alliant\", \"pphy\": \"DR. Meredith \", \"ppno\": \"\", \"cliId\": \"\", \"email\": \"MONICA.FURSE@GMAIL.COM\", \"ename\": \"Shakwaza Furse\", \"madd1\": \"706 Hall St\", \"madd2\": \"\", \"madd3\": \"\", \"mcity\": \"Augusta\", \"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\": \"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-20-2024\", \"time\": \"10:14:16\", \"value\": null, \"status\": false, \"component\": \"screening\"}]}], \"last_updated\": \"07-01-2024 10:21:26\"}', NULL, NULL, '{\"memberId\": \"0006056835001\", \"clinician\": \"Faith Enwefah\", \"qaAnalyst\": \"Judith Silverio\", \"queryData\": [{\"date\": \"Fri, 24 May 2024 20:36:36 GMT\", \"name\": \"Judith \", \"role\": \"qa\", \"files\": [], \"query\": {\"feedback\": \"1.  Demographics emergency contact info needs correction.\\n2.  Demographics please add additional  PCP info.\\n3.  Medication List the medications with allergy listed as diagnosis should it be sinusitis as reported in the DOA Nose section?  If yes please correct.\\nThanks\\nJudi\", \"response\": \"\"}, \"mailId\": \"\"}, {\"date\": \"Sat, 25 May 2024 14:52:58 GMT\", \"name\": \"Faith \", \"role\": \"nurse\", \"files\": [], \"query\": {\"feedback\": \"\", \"response\": \"Resolved.\\nThank you.\"}, \"mailId\": \"\"}], \"memberName\": \"MONICA FURSE\", \"codingAnalyst\": \"\", \"dateOfService\": \"05/22/2024 01:30 PM\", \"clinicianMailId\": \"f.enwefah@focuscares.com\", \"qaAnalystMailId\": \"j.silverio@focuscares.com\", \"codingAnalystMailId\": \"\"}', '{\"utc\": false, \"result\": 0, \"callLog\": [{\"date\": \"5/17/2024 @ 12:21 PM\", \"result\": 0, \"comment\": \"SCHEDULED FAITH ON 5/22 @ 2:00 - TEXTED LINK TO MEMBERS PHONE.\", \"inBound\": false, \"noAnswer\": -1, \"scheduler\": \"Shealese Reynolds\", \"callbackDate\": \"\"}, {\"date\": \"5/10/2024 @ 07:05 PM\", \"result\": 3, \"comment\": \"\", \"inBound\": false, \"noAnswer\": 0, \"scheduler\": \"Moira Roethle\", \"callbackDate\": \"5/11/2024 @ 07:05 PM\"}], \"visitType\": {\"type\": \"visitType\", \"memberId\": \"0006056835001\", \"visitType\": \"Virtual\"}, \"clinicianId\": {\"type\": \"assignMember\", \"nurseId\": \"62685179\", \"memberId\": \"0006056835001\"}, \"appointmentDate\": {\"type\": \"scheduleDate\", \"nurseId\": \"62685179\", \"memberId\": \"0006056835001\", \"scheduleDate\": \"2024-5-22T14:00\"}}', '{\"mail_details\": [], \"scheduler_details\": [{\"date\": \"05-10-2024 19:05:00\", \"schedulerId\": \"2661185\", \"schedulerLeadId\": \"2661185\"}]}', '{\"date\": \"05-17-2024 12:21:28\", \"status\": 1, \"details\": \"scheduled directly\", \"disabled\": false, \"notification\": null}', '{\"attemptCount\": 2}', NULL, 0, NULL, '[{\"date\": \"2024-05-31 14:34:41\", \"status\": 0, \"message\": \"Fax sent failed\", \"fax_response\": \"{\\\"transaction_id\\\":\\\"71b68f70-1f7c-11ef-b6bb-99522c1934cb\\\",\\\"errors\\\":[{\\\"error_code\\\":\\\"EMPTY_VALUE\\\",\\\"element_name\\\":\\\"destinations[0].fax_number\\\",\\\"developer_message\\\":\\\"Parameter [destinations[0].fax_number] is empty.\\\",\\\"user_message\\\":\\\"Parameter is empty.\\\",\\\"more_info\\\":\\\"https:\\\\/\\\\/consensus.stoplight.io\\\\/docs\\\\/fax-services\\\\/\\\"}]}\", \"fax_transmission_response\": {\"response\": \"{\\\"errors\\\":[{\\\"error_code\\\":\\\"Bad Request\\\",\\\"developer_message\\\":\\\"The request was rejected because the URL contained a potentially malicious String \\\\\\\"//\\\\\\\"\\\",\\\"user_message\\\":\\\"The request was rejected because the URL contained a potentially malicious String \\\\\\\"//\\\\\\\"\\\",\\\"more_info\\\":\\\"https://consensus.stoplight.io/docs/fax-services/\\\"}]}\", \"http_status_code\": 400}}]', 'Virtual', '2024-5-22T14:00', '2024-08-31', '2024-05-22T13:30', NULL, NULL, NULL, NULL, '123456789', '21-04-2024 05:59:35', NULL, NULL, NULL, NULL, '{\"year\": \"2024\", \"client_id\": \"client_009\", \"member_id\": \"0006056835001\", \"reason_hra\": \"uploaded for HRA Assessment\", \"reason_summary\": \"uploaded for Summary Assessment\", \"assessment_name\": \"ACA_0006056835001_FURSE, MONICA_05222024.pdf\", \"ftp_upload_date\": \"2024-05-31 14:34:41\", \"hra_uploadStatus\": \"success\", \"summary_uploadStats\": \"success\", \"summary_assessment_name\": \"PCP_, DR. Meredith_0006056835001_05222024.pdf\"}', 'ACA_0006056835001_FURSE, MONICA_05222024', NULL, 'PCP_, DR. Meredith_0006056835001_05222024', NULL, '[{\"date\": \"2024-05-22T18:31:25.616Z\", \"signature\": \"data:image/png;base64,[encoded data, 23404 characters]\"}, {\"date\": \"2024-05-25T14:52:58.095Z\", \"signature\": \"data:image/png;base64,[encoded data, 23400 characters]\"}]', '2024-05-22T14:30', 'Member_Summary_0006056835001.pdf', '{\"year\": \"2024\", \"client_id\": \"client_009\", \"member_id\": \"0006056835001\", \"member_uploadStatus\": \"success\", \"reason_member_upload\": \"uploaded Member Summary Report\", \"member_assessment_name\": \"Member_Summary_0006056835001.pdf\", \"member_ftp_upload_date\": \"2024-05-31 14:34:43\"}', NULL, NULL, NULL, NULL);
