Cerner: Extract medications from MedicationRequest contained/medicationreference fields

[dogversioning]

Occasionally, medications will be embedded in a different place in the MedicationRequest resource. Currently, the ETL is not fully extracting the required values. Once it is, we should extract display values for this dataset when building medication tables.

To see the state of the data, run the following query:

with contained_table as(
    SELECT t.contained, medicationreference
    FROM "cumulusdb-rnr2cmuwjxfk"."medicationrequest" as mr, --cerner
    unnest (mr.contained) as t(contained)
    where cardinality(mr.contained ) >0
)
select * from contained_table as ct
where ct.contained.resourcetype='Medication'

[mikix]

The ETL is fixed now - it allows contained Medications through and their IDs should match. So addressing this issue is now unblocked.

In terms of BCH data, I'll have to do a re-run of MedicationRequest now -- I can let you know when that's done.

[dogversioning]

resolved via #89 + #91