wiki:ETL

Resources

  • EPIC ETL help contact Robert Bradford at UNC robert_bradford@…

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.

These scripts are separate from the data quality measurements by year that we discussed in yesterday’s DH meeting. I am currently looking into modifying these scripts to generate patient counts by year in support of the DQ milestones. If anyone has already done this or has ideas &/or concerns about this, please contact me.

Last modified 9 months ago Last modified on 03/05/19 06:19:40