search

CDCgov / prime-field-teams

Apache License 2.0
1 stars 0 forks source link

Solution Dev - RS Schema #139

Closed rhood23699 closed 3 years ago

rhood23699 commented 3 years ago

Create an RS Schema based on the mapping file created by R.Hood

The mapping file is located at: https://drive.google.com/file/d/1ks63AVBMNNwzodPgbIhJAxSIFXeRupqQ/view?usp=sharing

rhood23699 commented 3 years ago

Herman is redoing the RS Schema based on our decision to use the original test file provided by Dylan.

rhood23699 commented 3 years ago

7/23/21 - Email'd Experity re" our questions and again requested a test file with several months of data using the original file format sent by Dylan. I also called him. Contact apologized and stated he would get answers to the questions and requested the test file sent by Dylan, so he could determine which report Dylan used. There are 3 lab reports, Lab1, Lab2 and Lab3. The file that was sent was Lab2 which contained all labs results both inhouse and sendouts, so the file Dylan sent is either Lab1 or Lab3. I email'd the test file to Experity contact.

Experity contact also provided a contact info for Compass Urgent Care in Mobile, AL. Heather has sent them a intro and meeting request email.

rhood23699 commented 3 years ago

Experity contact confirmed that the file received from Dylan is the Lab 3 report.

rhood23699 commented 3 years ago

I'll call Experity contact if I haven't heard from him by midday.

rhood23699 commented 3 years ago

I called the Experity contact and there has been no progress on creating a de-identified file from production or answering our questions.

hermanAlexCordero commented 3 years ago

Schema built in local instance and tested. Errors due to missing data.

adding dummy data when possible to test schema.

rhood23699 commented 3 years ago

Email'd the Experity contact for an update on creating a de-identified file from production or answering our questions.

hermanAlexCordero commented 3 years ago

Prototyped file completed local testing.

rhood23699 commented 3 years ago

Can you place the schema file into the Greenlight/Solutions folder, so I can run a few test too?

Thanks......Rick

Rick Hood Business Analyst 501 West Broadway, Suite 800 San Diego, CA 92101 @.***

Agile Six Applications, Inc. A Service-Disabled Veteran-Owned Small Business (SDVOSB)

www.Agile6.com http://www.agile6.com/

On Thu, Aug 5, 2021 at 2:09 PM hermanAlexCordero @.***> wrote:

Prototyped file completed local testing.

— You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub https://github.com/CDCgov/prime-field-teams/issues/139#issuecomment-893714949, or unsubscribe https://github.com/notifications/unsubscribe-auth/AUSS5CRXUEX7I3KOH6K5SLLT3LOU5ANCNFSM5AX4V3WQ . Triage notifications on the go with GitHub Mobile for iOS https://apps.apple.com/app/apple-store/id1477376905?ct=notification-email&mt=8&pt=524675 or Android https://play.google.com/store/apps/details?id=com.github.android&utm_campaign=notification-email .

rhood23699 commented 3 years ago

8/9/21 - Rick is working on the Schema while Herman works on the Reddy CSV file cleanup.

8/9/21 - Experity contact responded that the Lab 3 report can not be automated. We'll contact Experity contact to see if we can setup a Test Account with Experity or GUC to attempt to write a VBScript to automate the report.

rhood23699 commented 3 years ago

The Ordering Provider Names and NPIs are not matching in the CSV file. GUC and Experity are working on the resolution. This is the final data issue before we can move to Staging.

rhood23699 commented 3 years ago

Left a voicemail with our Experity contact to try to understand what is happening now with the provider names and NPIs, so I can fix the problems in the short-term in the Schema while GUC and/or Experity work on the long-term resolution.

rhood23699 commented 3 years ago

Closed. We have worked out how to handle the NPI issue with Greenlight.