Automation of Matching Contradictions

A stored procedure is used to automate the matching of contradictions. The stored procedure deals with three scenarios:

• One-to-one matches
• One-to-many matches: multiple values appear in the Contradictions column of the Findings and contradictions grid
• Many-to-many on Captions with sub-menus: many-to-many matches where sub-menu items are available on the Dynamic HPI Config template. The top parameter is a group 2 picklist popup with no Finding.

On Dynamic HPI Config, the contradictory list values appear in the Caption and Finding fields.

The stored procedure on the Dynamic HPI Contradictions Config template works with the sub-menu values by matching the Caption and Contradictions columns of the Findings and contradictions grid with the same positive values and then matching the two columns with the same negative values.

This makes it possible for the stored procedure to create mutually exclusive pairings between the positive and negative list values. An example from the pre-loaded Urology content is the Urinary tract infection HPI. If you select a Presenting Symptom of pain from the Positive grid, a list appears with all of the positive pain findings. Selecting denies pain from the Negative grid, opens a list with all of those values. The stored procedure overwrites any contradictory selections made by the user.

The concatenation appears as intended in run time. For example, if you select flank pain and open the denies pain list to select flank pain again, the concatenated text overwrites the first selection, from " is currently experiencing flank pain " to the second selection stating that the patient " is currently not experiencing flank pain. "