CDR based on values from LBT form

[bearzillasquatch (D C)]

I have a LBT form with several fields in it.

I’d like to have an alert when one of the fields value is a specific value for the patient. If i go to admin → practice → rules. I see there is an option to in the rule - clinical targets to specify one table and one field for the rule. But the lbt_data table doesn’t have patient identifying data like a pid.

So I’m wondering is there a way to set up the alert so that it checks the transactions table for the form id of the relevant data in the lbt_data table for this patient?

I’m not sure if I described the problem accurately. If anyone needs more info feel free to ask it.

[moussa]

Can you create a view that combines data from multiple tables?

Then use that table for your clincial reminder

How to Set Up Clinical Reminders for Prior Authorization Expiration

Background: Prior authorizations is need to be renewed to ensure continuous patient care and to prevent situations where services are rendered to a patient whose authorization has expired, leading to claim denials. Steps Install Advanced Prior Auth (Oe-module-prior-authorizations) from Modules → Manage Modules The Advanced Prior Auth module creates a table called module_prior_authorizations. This table has fields: id, pid, auth_num, start_date, end_date, cpt, init_units, and remaining_units…

[bearzillasquatch (D C)]

Got it. Create a view in the database then reference that view. that will probably make a few other things easier too.

Thanks, for the input.