OHDSI Home | Forums | Wiki | Github

How to map table with multiple role data into CDM?

(libeiwu) #1

Hi,I have some problems with the ETL process. For example, the database is focusing on an event, for example, delivery. If there is a table containing data for multiple roles, including parents, children, how to map these data into CDM? How to deal with the situation where multiple ID values coexist in a table? Thanks.

(Christian Reich) #2


Each Person is separate. The mother, the child, the father, all have a record in PERSON. They are then connected through FACT_RELATIONSHIP:

Hope this helps.