We receive two files from EPIC per affiliate every day: the Patient Visits file and the Future Visits file.
Future Visits File – Since this data is stored in Atlas only until the date of the visit, and since we’re getting a new file every day, there is no real value or need to keep more than a few days’ worth of files.
- The files are delivered to \\PHSQLAO4600A\EpicData\XXX (where XXX is the affiliate abbreviation)
- A script runs that
- Puts a copy of the original file in \\PHSQLAO4600A\EpicData\XXX\archive,
- Fixes some formatting issues,
- Compares the file to the previous day’s file to remove exact duplicate rows, and
- Moves the file updated to \\PHSQLAO4600A\ImportFiles\XXX, where it will be picked up and processed by BVDL.
- After import, BVDL moves the formatted files to \\PHSQLAO4600A\ImportFiles\XXX\Archive\EpicArchive. These files are kept for seven days and deleted.
Patient Visit Files –There have been a few instances where we needed to go back to the files to troubleshoot various issues.
- The files are delivered to \\PHSQLAO4600A\EpicData\XXX (where XXX is the affiliate abbreviation)
- These files will be kept for 6 months.
- A script runs that
- Puts a copy of the original file in \\PHSQLAO4600A\EpicData\XXX\archive,
- Fixes some formatting issues, and
- Moves the file updated to \\PHSQLAO4600A\ImportFiles\XXX, where it will be picked up and processed by BVDL.
- After import, the formatted files are archived again to \\PHSQLAO4600A\ImportFiles\XXX\Archive\EpicArchive. These files are kept for 30 days and deleted.
Good to Know!
- Add short bullets for important info about this area, conversion info, entry info, etc
How Do I?
- links to other areas, longer blurbs