Media files for the B10 data extraction tool will have a filename as shown in the exported_documents folder and a more descriptive URI when described in the CSV files.
Example:
The file 00cb030b6ee84b13bd692577c733e6af.pdf can be found at:
doctors/exported_documents/education_resource_files/00cb030b6ee84b13bd692577c733e6af.pdf
However, the same file is described in the doctors/education_resource_1.csv data file as:
clinical/education/00cb030b6ee84b13bd692577c733e6af.pdf
Notice that we add two namespaces, clinical and education before the filename. Below are the patterns for each media file and how to find them in the CSV data files.
1. Consent Form Files - consent_forms_file
Data File: consent_forms_<index>.csv
Media file root: /doctors/exported_documents/consent_forms_files
File URI format: hipaa_forms/<year>/<month>/<filename>.<extension>
hipaa_forms/2019/03/08fc5657-b113-4051-a341-cba603e0a59b.pdf
Example:
File: /doctors/exported_documents/consent_forms_files/08fc5657-b113-4051-a341-cba603e0a59b.pdf
Entry in data file:
- consent_forms_1.csv
- 39:False,False,2019-03-28 08:53:37,240601,220271,True,0,Doc Allemend release,2020-03-18 14:49:47,hipaa_forms/2019/03/08fc5657-b113-4051-a341-cba603e0a59b.pdf
2. Education Resouce Files - education_resource_file
Data File: education_resource_<index>.csv
Media file root: /doctors/exported_documents/education_resource_files
File URI format: clinical/education/<filename>.<extension>
clinical/education/00cb030b6ee84b13bd692577c733e6af.pdf
Example:
File: doctors/exported_documents/education_resource_files/00cb030b6ee84b13bd692577c733e6af.pdf
Entry in data file:
- education_resource_1.csv
- 4:False,0,2023-02-23 14:41:20,,238659,0,application/pdf,clinical/education/00cb030b6ee84b13bd692577c733e6af.pdf,,18108,,,[],english,,private,0,drchrono,False,Importance of Lifestyle Decisions,2023-02-23 14:41:20,
Patient Folder
1. - Clinical Note Files - clinical_note_file
Data File: clinical_notes_<index>.csv
Media file root: /patients/exported_documents/clinical_note_files
File URI format: clinical/<year>/<month>/<filename>.<extension>
clinical/2024/10/note_495197_311398510_3a0eb84b-1aa9-4fcc-8379-0502920cfedd.pdf
Example:
File: /patients/exported_documents/clinical_note_files/note_495197_311398510_3a0eb84b-1aa9-4fcc-8379-0502920cfedd.pdf
Entry in data file:
- clinical_notes_71.csv
- 290:311398510,2024-06-21 14:07:14.191231,700427.0,False,False,False,183809238,754795576.0,2024-06-21 15:55:25.256250,700427.0,True,clinical/2024/06/note_495197_311398510_3a0eb84b-1aa9-4fcc-8379-0502920cfedd.pdf,,,False,2024-06-21 16:55:25.262943
2. - Consent Form Signature Files - consent_form_signature_files
Data file: consent_form_signatures_<index>.csv
Media file root: /patients/exported_documents/consent_form_signature_files
File URI format: signed_consent_forms/240601_282234949_90406974_254573.pdf
signed_consent_forms/240601_282234949_90406974_254573.pdf
Example:
File: patients/exported_documents/consent_form_signature_files/364251_320423860_121468263_254573.pdf
Entry in data file:
- consent_form_signatures_402.csv
- 107:320423860,False,signed_consent_forms/364251_320423860_121468263_254573.pdf,254573,47935028,121468263,clinical/2024/08/238659_93b281ee-d3e9-4dc2-a55f-5179e413fe1b/238659_121468263_iphone_pho_RQTORmI.jpg,2024-09-27 12:06:35,2024-09-27 12:06:47
3. - Direct Message Attachment Files - direct_message_attachment_files
Data File: direct_message_attachment_<index>.csv
Media file root: /patients/exported_documents/direct_message_attachment_files
File URI format: dr_message_attachment/<year>/<month>/<filename>.<extension>
dr_message_attachment/2024/01/238659_4622e297-2b48-4461-9b0e-bc7d4dd3aa91.xml
Example:
File: /patients/exported_documents/direct_message_attachment_files/238659_4622e297-2b48-4461-9b0e-bc7d4dd3aa91.xml
Entry in data file:
- direct_message_attachment_38.csv
- 2:dr_message_attachment/2024/01/238659_4622e297-2b48-4461-9b0e-bc7d4dd3aa91.xml,91015,NIKA000001.ccda.xml,161448,application/hl7-v3+xml
4. - Doctor Message Files - doctor_message_files
Data File: doctor_message_<index>.csv
Media file root: /patients/exported_documents/doctor_message_files
File URI format: dr_message_attachment/<year>/<month>/<filename>.<extension>
dr_message_attachment/2022/12/240601_b940df8d-16ab-4c6d-bdac-4ea495d22fc0.pdf
Example:
File: /patients/exported_documents/doctor_message_files/240601_b940df8d-16ab-4c6d-bdac-4ea495d22fc0.pdf
Entry in data file:
- uploaded_documents_366.csv
- 21:,,False,0,,2024-07-30 12:29:22,2024-07-30,zepbound appeal paperwork0001.pdf,240417,clinical/2024/07/240417_27b302f4-8e57-435c-b691-b3cd27e3e1cf/zepbound_appeal_paperwork0001.pdf,,325307076,False,,,111496796,False,,2024-07-30 12:29:22
5. - Imported Clinical Care Document Files - imported_clinical_care_document_files
Data File: uploaded_documents_<index>.csv
Media file root: /patients/exported_documents/imported_clinical_care_document_files
File URI format: clinical/<year>/<month>/<hash>/<filename>.<extension>
clinical/2024/07/240417_27b302f4-8e57-435c-b691-b3cd27e3e1cf/zepbound_appeal_paperwork0001.pdf
Example:
File: /patients/exported_documents/imported_clinical_care_document_files/zepbound_appeal_paperwork0001.pdf
Entry in data file:
- inbound_referrals_127.csv
- 17:2023-01-13 10:59:09,,,,3773176,,,4991135,,inbound_faxes/2023/01/inbound_fax_0_ff2b1846-31af-4a8d-a09b-f252d1e23104.pdf,,39QKDJ84,2023-01-13 10:59:09
6. - Inbound Referrals Files - inbound_referrals_files
Data File: inbound_referrals_<index>.csv
Media file root: /patients/exported_documents/inbound_referrals_files
File URI format: inbound_referrals_files/<filename>.<extension>
inbound_referrals_files/inbound_fax_0_ff2b1846-31af-4a8d-a09b-f252d1e23104.pdf
Example:
File: /patients/exported_documents/inbound_referrals_files/zepbound_appeal_paperwork0001.pdf
Entry in data file:
- inbound_referrals_127.csv
- 17:2023-01-13 10:59:09,,,,3773176,,,4991135,,inbound_faxes/2023/01/inbound_fax_0_ff2b1846-31af-4a8d-a09b-f252d1e23104.pdf,,39QKDJ84,2023-01-13 10:59:09
7. - Outbound Referral Files - outbound_referrals_files
Data File: outbound_referrals_<index>.csv
Media file root: /patients/exported_documents/outbound_referrals_files
File URI format: referrals/<year>/<month>/<filename>.<extension>
referrals/2020/03/240601-ba2ca8ca-adb7-4365-8d85-cfd70b8fbddb.pdf
Example:
File: /patients/exported_documents/outbound_referrals_files/240601-ba2ca8ca-adb7-4365-8d85-cfd70b8fbddb.pdf
Entry in data file:
- outbound_referrals_15.csv
- 39:[],2020-03-25 09:47:47,2020-03-25,240601,RHClinic@allenparishhospital.com,,(337) 738-2713,[],2305485,False,Bmp cbc i10 ,53356221.0,255575,80679845,referrals/2020/03/240601-ba2ca8ca-adb7-4365-8d85-cfd70b8fbddb.pdf,,1528157.0,2020-03-25 09:47:55
8. - Patient Message Attachment Files - patient_message_attachment_files
Data File:
patient_message_attachment_<index>.csvuploaded_documents_<index>.csv
Media file root: /patients/exported_documents/patient_message_attachment_files
File URI format: clinical/<year>/<month>/<hash>/<filename>.<extension>
clinical/2019/11/238659_1d199213-3d2e-4e8d-897d-eb59c079d2c4/Med_Rec_Release_Dr_Younes31102019_8.pdf
Example:
File: /patients/exported_documents/patient_message_attachment_files/Med_Rec_Release_Dr_Younes31102019_8.pdf
Entry in data file:
- patient_message_attachment_16.csv
- 8:clinical/2019/11/238659_1d199213-3d2e-4e8d-897d-eb59c079d2c4/Med_Rec_Release_Dr_Younes31102019_8.pdf,,2020-01-03 17:26:44,ST JOSEPH HLTH SYSTEMS MED RECORDS,240601,7444161,1287150,2969486,134989949,100,0,True,80679925,2020-01-03 17:26:44
1. uploaded_documents_16.csv
2. 641:,,False,0,,2019-11-01 12:35:24,2019-11-01,ST JOSEPH HLTH SYSTEMS MED RECORDS,238659,clinical/2019/11/238659_1d199213-3d2e-4e8d-897d-eb59c079d2c4/Med_Rec_Release_Dr_Younes31102019_8.pdf,,134989949,False,,med recs,80679925,True,,2020-01-03 17:26:44