Find more information in the HemOnc cookbook here. Refresh of HemOnc:

Prerequisites:

• Schema DevV5 with copies of tables concept, concept_relationship and concept_synonym from ProdV5, fully indexed.
• Working directory HemOnc

1. Upload the source tables
2. Make sure that manual tables are populated with most recent content (see the https://github.com/OHDSI/Vocabulary-v5.0/blob/master/HemOnc/manual_work/readme_manual_tables.md)
3. Run load_stage.sql
4. Run generic_update:

DO $_$
BEGIN
	PERFORM devv5.GenericUpdate();
END $_$;

5. Run basic tables check (should retrieve NULL):

SELECT * FROM qa_tests.get_checks();

6. Run scripts to get summary, and interpret the results:

SELECT * FROM qa_tests.get_summary('concept');

SELECT * FROM qa_tests.get_summary('concept_relationship');

7. Run scripts to collect statistics, and interpret the results:

SELECT * FROM qa_tests.get_domain_changes();

SELECT * FROM qa_tests.get_newly_concepts();

SELECT * FROM qa_tests.get_standard_concept_changes();

SELECT * FROM qa_tests.get_newly_concepts_standard_concept_status();

SELECT * FROM qa_tests.get_changes_concept_mapping();

8. Run manual_checks_after_generic.sql, and interpret the results.

If no problems, enjoy!