Add complete set of tests to all sources

[vvcb]

We need all sources (which represent the bronze layer ingested from on-prem) to have a comprehensive set of tests. Let's document what these tests need to be on this issue and start picking these off in batches.

~Currently all sources are listed in ./models/sources.yml. We may want to split this into multiple files at a later stage.~

Sources are documented in multiple yaml files under ./models/omop_sources.

[quindavies]

Quin

• [x] care_site
• [x] cdm_source
• [x] cohort
• [x] cohort_definition
• [x] concept
• [x] concept_ancestor
• [x] concept_class
• [x] concept_relationship
• [x] concept_synonym
• [x] condition_era
• [x] condition_occurrence
• [x] cost
• [x] death
• [x] device_exposure
• [x] domain
• [x] dose_era
• [x] drug_era
• [x] drug_exposure
• [x] drug_strength

Tim

• [x] episode
• [x] episode_event
• [x] fact_relationship
• [x] location
• [x] measurement
• [x] metadata
• [x] note
• [x] note_nlp
• [x] observation
• [x] observation_period
• [x] payer_plan_period
• [x] person
• [x] procedure_occurrence
• [x] provider
• [x] relationship
• [x] specimen
• [x] visit_detail
• [x] visit_occurrence
• [x] vocabulary

[quindavies]

@vvcb can you comment which of the sources files you’re planning on completing so we can update the list above? Otherwise we’re going to be duplicating work we started yesterday.

[vvcb]

I didn't see any new changes or branches on the repo last night and didn't expect anyone to be working on this at 2am :-)

I have done a pile of work which has all been pushed to this repo on the main branch. It gives a good starting point.

Rather than write all the tests per model, it was easier , more efficient to setup the same group of tests for multiple columns across multiple sources.

[quindavies]

Okay so you're not going to do anymore for now so we don't need to redo the list above?

[quindavies]

OMOP specific tests complete Date test discussion continued on https://github.com/lsc-sde/dbt_omop_rxn_silver/issues/11