Page History
...
The following steps will load the OMOP metadata and CRC tables and the OMOP Views required to query the OMOP tables: i2b2-on-OMOP With ENACT-OMOP Ontology v4.1
...
ACT
...
Step 3: Execute Totalnum counts
...
OMOP
...
exec totalnum_fast_prep_OMOP 'observation_fact','dbo','@
When finished, verify by checking that c_totalnum columns in your ontology tables contain numbers. These total counts will be visible in the ontology browser in the web client for 2b2 users with DATA_AGG user permission.
| Info |
|---|
Ontologies derived from visit_dimension or patient_dimension top folders will not have counts because of the way these terms are defined and cannot be rolled up. |
ACT OMOP Totalnum Scripts
Totalnum Scripts (patient counting scripts) have been updated to improve the counter's performance on both multiple ontology tables and very large(>1.5 million) ontologies such as ACT medications. Debug messages have also been added for troubleshooting and profiling purposes. Support for multiple fact tables has been added and bugfixes have been made.
...
DATA-33 MSSQL Version of Faster Patient Counting Scripts DATA-23 Support for multiple crc zip file extraction using databuld.xml DATA 16 and 36 |
Bug Fixes
| Core-server |
|---|
CORE-440 Queries from queue are not processing and returning back CORE-441 DB Locking issue- can't show previous query when a query is running CORE-442 Get_children doesn't work on Modifier folders CORE-444 Breakdowns for non-Patient_dimension views - don't work CORE-443 Breakdown queueing CORE 445 and 446 |
Notes for Developers
For Java 11 install, if you change the xsd (REST API message definitions), then you will need to regenerate gensrc via JAXB in Java 8. In the i2b2-core cell directory for which you're regenerating the XSD-Java, run the ant target "jaxb_gen" on Java 8 and then build as usual using Java 11.
...
