search

ARCH-commons / i2p-transform

i2b2 to PCORnet Common Data Model Transformation - requires i2b2 PCORnet ontology
Other
3 stars 16 forks source link

Encounter should not transform Aetna payer_type #75

Closed jklann closed 6 years ago

jklann commented 6 years ago

The encounter transform needs to exclude Aetna payer_type, because pcornet does not recognize these as valid values.

jklann commented 6 years ago

Fixed in MSSQL e31ed791c754d2d2f76db97979778266183d7f50

Also this SQL code will remove them from an extant encounter table in a pinch:

-- Delete Aetna codes, which are ARCH specific update pmnENCOUNTER set PAYER_TYPE_PRIMARY=null where PAYER_TYPE_PRIMARY like 'A%'

jklann commented 6 years ago

Fixed in Oracle: 2d47f5662e67c16545c4f6377e50f73494d33fb5