Applies to Versions: DVMAX 7v7.0.11 and Up
Operarting System: Macintosh & Windows
Difficulty: Moderate
-v8.7.3
Purpose: While there is already a reference to insert history entries onto a Word Processing document, there are occasions where one may want to insert their findings into different sections of a document instead of all together. This document covers how to spread the finding items of a specific MRE into several locations of a Word Processing document.
Assuming you have an Medical Record Entry for 'Wellness Exam', which has findings for:
Presenting Complaint
Clinical Findings
Assessment
Conclusion
You decide to create a document in Word Processing and want all 4 findings to appear, but in separate sections. You can accomplish this by doing the following:
...
Open an existing Protected Document you have, or create a new one.
Place your cursor where you want the specific finding item value to appear.
Go to the Insert menu and choose 4D Expression.
Click on the Expression tab, then click the Edit button.
A Formula Editor window will open.
In the lower section is a single line that you can type in. Enter in the following (cut and paste):
For DVMAX 7.0:
fndngs_return_FC_finding_text([Patients]Patient ID;"Finding_Class_Code";"Finding_Item_Name"; Days_Back)
For DVMAX 7.5 and higher-8.7.3:
fndngs_return_FC_finding_text([Patients]Patient_ID;"Finding_Class_Code";"Finding_Item_Name"; Days_Back)
Replace Finding_Class_Code with the Code found in Step 1.
Replace Finding_Item_Name with the Finding item you want to insert in this specific position.
Replace Days_Back with the number of days back you want the program to search through Patient History for information.
Continuing to use our example, we would enter:
For DVMAX 7.0:
fndngs_return_FC_finding_text([Patients]Patient ID;"ExamFind";"Presenting Complaint"; 3)
For DVMAX 7.5 and higher-8.7.3:
fndngs_return_FC_finding_text([Patients]Patient_ID;"ExamFind";"Presenting Complaint"; 3)
This would insert any Presenting Complaint notes of a MRE that uses the ExamFind Finding Class in the Patient's record over the past 3 days.
Once the formula is added, click OK to close the Formula Editor window.
Click OK again to close the 4D Expression window.
The result should be any text from the Patient's history that meets the formula's criteria.
You can then repeat the same process into multiple places on your document for different Finding items.
Alternatively, but far less used, you could drill this down to the MRE level instead, using the following formula:
For DVMAX 7.0:
fndngs_return_MRE_finding_text([Patients]Patient ID;"MRC_Code";"Finding_Item_Name"; Days_Back)
For DVMAX 7.5 and higher-8.7.3:
fndngs_return_MRE_finding_text([Patients]Patient_ID;"MRC_Code";"Finding_Item_Name"; Days_Back)