Skip to content
pottmar edited this page Dec 2, 2019 · 3 revisions

Calculating and Populating the c_totalnum Field

A set of scripts for calculating and populating the c_totalnum field of the metadata tables can be found here: ​https://docrepo.ctsi.pitt.edu/nxps/nxps?action=viewObject&objId=154012 These scripts are written for SQLServer and calculate patient counts across the entire local i2b2 instance. While not required, it is generally recommended that you populate the c_totalnum field for query performance reasons. Be sure to read the README file before running the scripts. These scripts were previously sent via email on Feb 19; the scripts posted above are identical.

Resources

For EPIC ETL help, please contact Robert Bradford at [email protected].