Details
-
Sub-Task
-
Status: In Review
-
Major
-
Resolution: Unresolved
-
None
-
None
-
None
Description
Add support for multiple fact tables on the totalnum counter scripts for all database platforms.
To use with multi-fact setups: Create a fact table view as the union of all your fact tables. (This is essentially going back to a single fact table, but it is only used for totalnum counting. This is needed to correctly count patients that mention multiple fact tables within a hierarchy.)
e.g.,
create view observation_fact_view as
select * from CONDITION_VIEW
union all
select * from drug_view
And then run the totalnum counter on that fact table view.