English

Location History

1 forms  
  1. StudyEvent: ODM
    1. Location History
Location History
Description

Location History

Alias
UMLS CUI-1
C0450429
UMLS CUI-2
C1442065
UMLS CUI-3
C1955348
UMLS CUI-4
C0337950
UMLS CUI-5
C0019664
Location ID
Description

A foreign key to the location table.

Data type

integer

Alias
UMLS CUI [1,1]
C0450429
UMLS CUI [1,2]
C1300638
Relationshio type concept ID
Description

The type of relationship between location and entity. When the domain is PERSON, the permissible values of relationship_type are: 'residence', 'work site', 'school'. When the domain is CARE_SITE, the value of relationship_type is NULL. When the domain is PROVIDER, the value of relationship_type is 'office'. (Type varchar(50))

Data type

text

Alias
UMLS CUI [1,1]
C1551338
UMLS CUI [1,2]
C0450429
UMLS CUI [1,3]
C0439849
UMLS CUI [1,4]
C0332307
UMLS CUI [1,5]
C0178566
UMLS CUI [1,6]
C1300638
Domain ID
Description

The domain of the entity that is related to the location. Either PERSON, PROVIDER, or CARE_SITE. DOMAIN_ID specifies which table the ENTITY_ID refers to. (Type varchar(50))

Data type

text

Alias
UMLS CUI [1,1]
C1883204
UMLS CUI [1,2]
C1300638
Entity ID
Description

The unique identifier for the entity. References either person_id, provider_id, or care_site_id, depending on domain_id.

Data type

integer

Alias
UMLS CUI [1,1]
C1551338
UMLS CUI [1,2]
C0600091
Start date
Description

The date the relationship started.

Data type

date

Alias
UMLS CUI [1]
C0808070
End date
Description

The date the relationship ended.

Data type

date

Alias
UMLS CUI [1]
C0806020
Back to the top of the page

Similar models

Location History

1 forms
  1. StudyEvent: ODM
    1. Location History
Name
Type
Description | Question | Decode (Coded Value)
Data type
Alias
Item Group
Location History
C0450429 (UMLS CUI-1)
C1442065 (UMLS CUI-2)
C1955348 (UMLS CUI-3)
C0337950 (UMLS CUI-4)
C0019664 (UMLS CUI-5)
Item
Location ID
integer
C0450429 (UMLS CUI [1,1])
C1300638 (UMLS CUI [1,2])
Location ID
Code List
Location ID
Relationshio type concept ID
Item
Relationshio type concept ID
text
C1551338 (UMLS CUI [1,1])
C0450429 (UMLS CUI [1,2])
C0439849 (UMLS CUI [1,3])
C0332307 (UMLS CUI [1,4])
C0178566 (UMLS CUI [1,5])
C1300638 (UMLS CUI [1,6])
Item
Domain ID
text
C1883204 (UMLS CUI [1,1])
C1300638 (UMLS CUI [1,2])
Domain ID
Code List
Domain ID
CL Item
Person (a)
CL Item
Provider (b)
CL Item
Care Site (c)
Entity ID
Item
Entity ID
integer
C1551338 (UMLS CUI [1,1])
C0600091 (UMLS CUI [1,2])
Start date
Item
Start date
date
C0808070 (UMLS CUI [1])
End date
Item
End date
date
C0806020 (UMLS CUI [1])
Back to the top of the page