Person

Source file: person.py

Root XPath

./hl7:recordTarget/hl7:patientRole

Expected OMOP domain: Person

Fields

Field

Type

Order

Details

person_id

DERIVED

1

VT.map_filename_to_mspi(filename=filename)

gender_concept_id

PRIORITY

2

coalesce candidates by priority

year_of_birth

DERIVED

3

VT.extract_year_of_birth(date_object=birth_datetime)

month_of_birth

DERIVED

4

VT.extract_month_of_birth(date_object=birth_datetime)

day_of_birth

DERIVED

5

VT.extract_day_of_birth(date_object=birth_datetime)

birth_datetime

FIELD

6

hl7:patient/hl7:birthTime @value [DATETIME]

race_concept_id

PRIORITY

7

coalesce candidates by priority

ethnicity_concept_id

PRIORITY

8

coalesce candidates by priority

location_id

HASH

9

hash(address_1, city, state, zip)

provider_id

None

10

—

care_site_id

CONSTANT

11

0

person_source_value

CONSTANT

12

gender_source_value

PRIORITY

13

coalesce candidates by priority

gender_source_concept_id

None

14

—

race_source_value

PRIORITY

15

coalesce candidates by priority

race_source_concept_id

None

16

—

ethnicity_source_value

PRIORITY

17

coalesce candidates by priority

ethnicity_source_concept_id

None

18

—

data_partner_id

DERIVED

20

VT.get_data_partner_id(filename=filename)

filename

FILENAME

100

source XML filename

cfg_name

CONSTANT

101

Person

address_1

FIELD

hl7:addr/hl7:streetAddressLine @#text

city

FIELD

hl7:addr/hl7:city @#text

ethnicity_concept_codeSystem_direct

FIELD

hl7:patient/hl7:ethnicGroupCode[not(@nullFlavor="OTH")] @codeSystem

ethnicity_concept_codeSystem_sdtc

FIELD

hl7:patient/sdtc:ethnicGroupCode @codeSystem

ethnicity_concept_codeSystem_translated

FIELD

hl7:patient/hl7:ethnicGroupCode/hl7:translation @codeSystem

ethnicity_concept_code_direct

FIELD

hl7:patient/hl7:ethnicGroupCode[not(@nullFlavor="OTH")] @code

ethnicity_concept_code_sdtc

FIELD

hl7:patient/sdtc:ethnicGroupCode @code

ethnicity_concept_code_translated

FIELD

hl7:patient/hl7:ethnicGroupCode/hl7:translation @code

ethnicity_concept_id_direct

DERIVED

VT.codemap_xwalk_concept_id(concept_code=ethnicity_concept_code_direct, vocabulary_oid=ethnicity_concept_codeSystem_direct, default=None)

ethnicity_concept_id_sdtc

DERIVED

VT.codemap_xwalk_concept_id(concept_code=ethnicity_concept_code_sdtc, vocabulary_oid=ethnicity_concept_codeSystem_sdtc, default=None)

ethnicity_concept_id_translated

DERIVED

VT.codemap_xwalk_concept_id(concept_code=ethnicity_concept_code_translated, vocabulary_oid=ethnicity_concept_codeSystem_translated, default=None)

ethnicity_source_value_direct

FIELD

hl7:patient/hl7:ethnicGroupCode @code → priority (‘ethnicity_source_value’, 1)

ethnicity_source_value_sdtc

FIELD

hl7:patient/sdtc:ethnicGroupCode @code → priority (‘ethnicity_source_value’, 2)

ethnicity_source_value_translated

FIELD

hl7:patient/hl7:ethnicGroupCode/hl7:translation @code → priority (‘ethnicity_source_value’, 3)

gender_concept_codeSystem_direct

FIELD

hl7:patient/hl7:administrativeGenderCode[not(@nullFlavor="OTH")] @codeSystem

gender_concept_codeSystem_translated

FIELD

hl7:patient/hl7:administrativeGenderCode/hl7:translation @codeSystem

gender_concept_code_direct

FIELD

hl7:patient/hl7:administrativeGenderCode[not(@nullFlavor="OTH")] @code

gender_concept_code_translated

FIELD

hl7:patient/hl7:administrativeGenderCode/hl7:translation @code

gender_concept_id_direct

DERIVED

VT.codemap_xwalk_concept_id(concept_code=gender_concept_code_direct, vocabulary_oid=gender_concept_codeSystem_direct, default=None)

gender_concept_id_translated

DERIVED

VT.codemap_xwalk_concept_id(concept_code=gender_concept_code_translated, vocabulary_oid=gender_concept_codeSystem_translated, default=None)

gender_source_value_direct

FIELD

hl7:patient/hl7:administrativeGenderCode @code → priority (‘gender_source_value’, 1)

gender_source_value_translated

FIELD

hl7:patient/hl7:administrativeGenderCode/hl7:translation @code → priority (‘gender_source_value’, 2)

person_id_extension

FIELD

hl7:id[not(@nullFlavor="UNK")] @extension

person_id_root

FIELD

hl7:id[not(@nullFlavor="UNK")] @root

race_concept_codeSystem_direct

FIELD

hl7:patient/hl7:raceCode[not(@nullFlavor="OTH")] @codeSystem

race_concept_codeSystem_sdtc

FIELD

hl7:patient/sdtc:raceCode @codeSystem

race_concept_codeSystem_translated

FIELD

hl7:patient/hl7:raceCode/hl7:translation @codeSystem

race_concept_code_direct

FIELD

hl7:patient/hl7:raceCode[not(@nullFlavor="OTH")] @code

race_concept_code_sdtc

FIELD

hl7:patient/sdtc:raceCode @code

race_concept_code_translated

FIELD

hl7:patient/hl7:raceCode/hl7:translation @code

race_concept_id_direct

DERIVED

VT.codemap_xwalk_concept_id(concept_code=race_concept_code_direct, vocabulary_oid=race_concept_codeSystem_direct, default=None)

race_concept_id_sdtc

DERIVED

VT.codemap_xwalk_concept_id(concept_code=race_concept_code_sdtc, vocabulary_oid=race_concept_codeSystem_sdtc, default=None)

race_concept_id_translated

DERIVED

VT.codemap_xwalk_concept_id(concept_code=race_concept_code_translated, vocabulary_oid=race_concept_codeSystem_translated, default=None)

race_source_value_direct

FIELD

hl7:patient/hl7:raceCode @code → priority (‘race_source_value’, 1)

race_source_value_sdtc

FIELD

hl7:patient/sdtc:raceCode @code → priority (‘race_source_value’, 2)

race_source_value_translated

FIELD

hl7:patient/hl7:raceCode/hl7:translation @code → priority (‘race_source_value’, 3)

state

FIELD

hl7:addr/hl7:state @#text

zip

FIELD

hl7:addr/hl7:postalCode @#text

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)