Crosswalk · Tool 05

ETL Decision Log

Every FHIR to OMOP pipeline makes decisions the source data did not make for it. This tool records those decisions while you still remember why you made them, and exports the record as markdown you can paste into a repository, a protocol, or a data quality report.

Start from a common decision

These are the choices most pipelines have to make. Selecting one fills in the question and a starting point for the reasoning, which you then edit to match what you actually did.

Record a decision

The decision

Affected table or area

Effect on what can be asked

What we did

Why we did it

What this costs a future researcher The question a study team can no longer ask, or can only ask with a caveat. Leave nothing here only when the honest answer is nothing.

Rows or people affected

Revisit when

The log

0 decisions recorded

A decision log is not a confession. It is the part of the documentation that lets a reviewer trust the rest of it. A pipeline with twenty recorded assumptions is easier to defend than one with none, because the second one made the same twenty decisions without telling anyone.