Creating the Stored Procedure

There are two stored procedures used by Omni-Patient HealthViews:

• fn_hvpartscollector
• fn_hvtabstatcollector

SQL scripts for creating both stored procedures are provided in the /stored_procs directory. They should be installed in the public schema.