moussa
January 9, 2026, 12:25am
2
Hi @sajanasigdel ,
I have done something similar a while ago
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…
and you should be able to do so by using the build in rules and alerts .
Add Rule –> ? –> ? –> Not sure if it is criteria or something else but you would see Custom Table from there you would select Table users_secure , and column last_update_password
