Services > Tips & Tricks > Last Patient Encounter

• services
• education
  • schedule
  • classes
    • accelerated diver
    • advanced data integration
    • control charts in diver
    • dial / di-analyst scripting
    • diveline administration
    • configuring user security
    • diveport administration
    • diver advanced
    • diver basics
    • diver graphics
    • diver intermediate
    • intro to data integration
    • intro to the diver solution
    • model design
    • report palette
    • report writer
  • courses
  • local interest
  • hotels
  • transportation
  • directions
  • cancellation policy
• tech support
• consulting
• on-demand bi
• platforms
• tips

To access our tip & trick library, CLICK HERE.

last patient encounter

Developers, want to show the Last Visit Date for a patient?

By including dates in your Model as Summary values, the Model can identify the last patient encounter (visit) date. Dates are stored as integer numbers in the Model, representing the number of days since December 31, 1899. Since the date is stored as a number, we can use the Maximum Sum type.

You will use two applications: Visual Builder and ProDiver, to create the Last Patient Encounter column.

in visual builder

Open Visual Builder to create a new description file or use an existing one.

1. Recognize Date Values

a. Re-classify the date field as a Summary. Be sure to set the Column Properties to recognize the date values. Check the “Column Contains Dates” option then set the appropriate the Date Formatting.

2. Set the Build Specification Options

a. Continue to the Build Specification Options dialog.

b. Check the Maximum option in the Sum Types section. Do not uncheck Total.

c. Select Finish.

3. Rebuild the Model

a. Select Model > Build Model… from the menu.

in prodiver

4. Add a Maximum Summary Column

a. Open the Model and dive on “Patient”.

b. To add a new column, double-click in the empty header area on the open Dive Window to display the Add Column dialog.

c. Select Max from the Model Columns section, and then select the “Encounter Date” from the list of Summary columns. The Definition is set to: Maximum[Encounter Date]

d. Rename the column to “Last Patient Encounter” or “Date of Last Visit”.

e. On the Options tab, Format the column as a Date and set the appropriate Date Formatting.

f. Open a new dive window and dive on Physician then dive on Patient. The Last Patient Encounter for each of the physician patient’s is now displayed.

Figure 1

Figure 2

Figure 3

Figure 4

Figure 5