ID

35586

Beskrivning

OMOP Common Data Model (CDM) Location The tables LOCATION, LOCATION HISTORY, CARE SITE and PROVIDER describe the healthcare provider system responsible for administering the healthcare of the patient, rather than the demographic or clinical events the patient experienced. The LOCATION table represents a generic way to capture physical location or address information of Persons and Care Sites. OMOP Common Data Model Version 6.0 Specifications 11October2018. The Observational Medical Outcomes Partnership (OMOP) was a public-private partnership established to inform the appropriate use of observational healthcare databases for studying the effects of medicalproducts. © 2014 Observational Health Data Sciences and Informatics. This work is based on work by the Observational Medical Outcomes Partnership (OMOP) and used under license from the FNIH at http://omop.fnih.org/publiclicense. Version updated on 11.03.2019, from https://github.com/OHDSI/CommonDataModel/wiki/LOCATION Each address or Location is unique and is present only once in the table. Locations do not contain names, such as the name of a hospital. In order to construct a full address that can be used in the postal service, the address information from the Location needs to be combined with information from the Care Site. The PERSON table does not contain name information at all. All fields in the Location tables contain the verbatim data in the source, no mapping or normalization takes place. None of the fields are mandatory. If the source data have no Location information at all, all Locations are represented by a single record. Typically, source data contain full or partial zip or postal codes or county or census district information. For standardized geospatial visualization and analysis, addresses need to be, at the minimum be geocoded into latitude and longitude. This allows it to put as a point on a map. This proposal is to add two fields, latitude and longitude to the location table.

Länk

http://omop.fnih.org/publiclicense

Nyckelord

Versioner (2)
  1. 2017-01-04 2017-01-04 -
  2. 2019-03-11 2019-03-11 -
Rättsinnehavare

Observational Medical Outcomes Partnership (OMOP)

Uppladdad den

11 mars 2019

DOI

För en begäran logga in.

Licens

Creative Commons BY-NC 3.0
Modellkommentarer :

Här kan du kommentera modellen. Med hjälp av pratbubblor i Item-grupperna och Item kan du lägga in specifika kommentarer.

Tillbaka till modellkommentarer
Itemgroup-kommentar för :

Item-kommentar för :

Du måste vara inloggad för att kunna ladda ner formulär. Var vänlig logga in eller registrera dig utan kostnad.

OMOP Common Data Model (CDM)

Engelsk

Location

1 Formulär  
  1. StudyEvent: ODM
    1. Location
Location
Beskrivning

Location

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

A unique identifier for each geographic location.

Datatyp

integer

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

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

Datatyp

text

Alias
UMLS CUI [1]
C1442065
Address 2
Beskrivning

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

Datatyp

text

Alias
UMLS CUI [1]
C1442065
City
Beskrivning

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

Datatyp

text

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

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

Datatyp

text

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

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))

Datatyp

text

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

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))

Datatyp

text

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

The country. (Type varchar(100))

Datatyp

text

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

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

Datatyp

text

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

The geocoded latitute

Datatyp

float

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

The geocoded longitude

Datatyp

float

Alias
UMLS CUI [1,1]
C1657623
UMLS CUI [1,2]
C1442065
Tillbaka till toppen

Similar models

Location

1 Formulär
  1. StudyEvent: ODM
    1. Location
Name
Typ
Description | Question | Decode (Coded Value)
Datatyp
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])
Tillbaka till toppen 

Kontakt

Använd detta formulär för feedback, frågor och förslag på förbättringar.

Fält markerade med * är obligatoriska.

Hjälp

Do you need help on how to use the search function? Please watch the corresponding tutorial video for more details and learn how to use the search function most efficiently.

Watch Tutorial