OHDSI Home | Forums | Wiki | Github

Location_history


(Nadya Zvyagina) #1

Hello all,

I am trying to populate location_history table. There are 2 unclear points:

  1. On wiki page I see relationship_type_concept_id of varchar(50) type.
    But DDL for 6.0 contains this field of bigint type.

  2. DDL contains location_history_id but there is no this field in wiki.

Could you please advise what is correct?


(Christian Reich) #2

That one. All concept_ids are integers or bigints.

That’s correct. Do you have location history in the data?


(Nadya Zvyagina) #3

Yes, I do have.


(Nadya Zvyagina) #4

What concept_id may I use as relationship_type_concept_id?


(Jae Hyeong Cho) #5

@Christian_Reich We also want to create a location_history table. Could you tell me what concept_id should I use for relationship_type_concept_id?


(Christian Reich) #6

We don’t have any right now. So, use 0.

Type Concepts describe the provenance of the record, so you can assess it’s reliability and utility. So, we probably need something like “Patient admission record” or “Insurance Claim”. Please propose if you have needs.


t