MyDomain
Source file: TEMPLATE.py
Root XPath
./hl7:component/hl7:structuredBody/hl7:component/hl7:section/hl7:templateId[@root='2.16.840.1.113883.10.20.22.2.5.1']/../hl7:entry/hl7:act/hl7:entryRelationship/hl7:observation
Expected OMOP domain: Condition
Fields
Field |
Type |
Order |
Details |
|---|---|---|---|
my_domain_id |
HASH |
1 |
hash(person_id, my_concept_code, my_concept_code_system, my_start_date, my_end_date) |
person_id |
FK |
2 |
FK → |
my_concept_id |
DERIVED |
3 |
|
my_start_date |
FIELD |
4 |
|
my_end_date |
FIELD |
5 |
|
my_type_concept_id |
CONSTANT |
8 |
|
provider_id |
FK |
11 |
FK → |
visit_occurrence_id |
FK |
12 |
FK → |
visit_detail_id |
None |
13 |
— |
filename |
FILENAME |
100 |
source XML filename |
cfg_name |
CONSTANT |
101 |
|
domain_id |
DERIVED |
|
|
my_concept_code |
FIELD |
|
|
my_concept_code_system |
FIELD |
|
Config type reference
config_type |
Meaning |
|---|---|
ROOT |
Defines the XPath root element for this config |
FIELD |
Extracts an XML attribute value via XPath |
DERIVED |
Computed by a Python function from other fields |
HASH |
MD5/hash of a set of fields, used as a surrogate key |
FK |
Foreign key copied from a joined dataset |
CONSTANT |
Fixed literal value written to every row |
PRIORITY |
Coalesces the first non-null value from prioritized candidates |
FILENAME |
The source XML filename |
None |
Not populated (placeholder) |