1. StudyEvent: ODM
    1. Location
Location
Description

Location

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

A unique identifier for each geographic location.

Type de données

integer

Alias
UMLS CUI [1,1]
C0450429
UMLS CUI [1,2]
C1300638
Address 1
Description

The address field 1, typically used for the street address, as it appears in the source data. (Type varchar(50))

Type de données

text

Alias
UMLS CUI [1]
C1442065
Address 2
Description

The address field 2, typically used for additional detail such as buildings, suites, floors, as it appears in the source data. (Type varchar(50))

Type de données

text

Alias
UMLS CUI [1]
C1442065
City
Description

The city field as it appears in the source data. (Type varchar(50))

Type de données

text

Alias
UMLS CUI [1,1]
C0008848
UMLS CUI [1,2]
C1442065
State
Description

The state field as it appears in the source data. (Type varchar(2))

Type de données

text

Alias
UMLS CUI [1,1]
C1301808
UMLS CUI [1,2]
C1442065
Zip
Description

The zip or postal code. Zip codes are handled as strings of up to 9 characters length. For US addresses, these represent either a 3-digit abbreviated Zip code as provided by many sources for patient protection reasons, the full 5-digit Zip or the 9-digit (ZIP + 4) codes. Unless for specific reasons analytical methods should expect and utilize only the first 3 digits. For international addresses, different rules apply. (Type varchar(9))

Type de données

text

Alias
UMLS CUI [1,1]
C1521842
UMLS CUI [1,2]
C1442065
UMLS CUI [2,1]
C1514254
UMLS CUI [2,2]
C1442065
County
Description

The county. The county information can be provided and is not redundant with information from the zip codes as not all of these have an unambiguous county designation. (Type varchar(20))

Type de données

text

Alias
UMLS CUI [1,1]
C0079170
UMLS CUI [1,2]
C1442065
Country
Description

The country. (Type varchar(100))

Type de données

text

Alias
UMLS CUI [1,1]
C0454664
UMLS CUI [1,2]
C1442065
Location source value
Description

The verbatim information that is used to uniquely identify the location as it appears in the source data. (Type varchar(50))

Type de données

text

Alias
UMLS CUI [1,1]
C0450429
UMLS CUI [1,2]
C0449416
Latitude
Description

The geocoded latitute

Type de données

float

Alias
UMLS CUI [1,1]
C1627936
UMLS CUI [1,2]
C1442065
Longitude
Description

The geocoded longitude

Type de données

float

Alias
UMLS CUI [1,1]
C1657623
UMLS CUI [1,2]
C1442065

Similar models

  1. StudyEvent: ODM
    1. Location
Name
Type
Description | Question | Decode (Coded Value)
Type de données
Alias
Item Group
Location
C0450429 (UMLS CUI-1)
C1442065 (UMLS CUI-2)
C1955348 (UMLS CUI-3)
C0337950 (UMLS CUI-4)
Location ID
Item
Location ID
integer
C0450429 (UMLS CUI [1,1])
C1300638 (UMLS CUI [1,2])
Address 1
Item
Address 1
text
C1442065 (UMLS CUI [1])
Address 2
Item
Address 2
text
C1442065 (UMLS CUI [1])
City
Item
City
text
C0008848 (UMLS CUI [1,1])
C1442065 (UMLS CUI [1,2])
State
Item
State
text
C1301808 (UMLS CUI [1,1])
C1442065 (UMLS CUI [1,2])
Zip
Item
Zip
text
C1521842 (UMLS CUI [1,1])
C1442065 (UMLS CUI [1,2])
C1514254 (UMLS CUI [2,1])
C1442065 (UMLS CUI [2,2])
County
Item
County
text
C0079170 (UMLS CUI [1,1])
C1442065 (UMLS CUI [1,2])
Country
Item
Country
text
C0454664 (UMLS CUI [1,1])
C1442065 (UMLS CUI [1,2])
Location source value
Item
Location source value
text
C0450429 (UMLS CUI [1,1])
C0449416 (UMLS CUI [1,2])
Latitude
Item
Latitude
float
C1627936 (UMLS CUI [1,1])
C1442065 (UMLS CUI [1,2])
Longitude
Item
Longitude
float
C1657623 (UMLS CUI [1,1])
C1442065 (UMLS CUI [1,2])