“器械”域用來記錄就診居民暴露于外來物理對象或儀器的信息，即通過非化學(xué)作用的機制用于診斷或治療目的的物質(zhì)暴露信息。器械包括可植入物（例如心臟起搏器翎碑，支架，人工關(guān)節(jié)）之斯，醫(yī)療器械和用品（例如繃帶日杈，拐杖，注射器），醫(yī)療程序中使用的其他器械（例如縫合線莉擒，除顫器）和臨床護理中使用的材料（例如粘合劑酿炸，基質(zhì)，牙科材料涨冀，手術(shù)材料）填硕。
The 'Device' domain captures information about a person's exposure to a foreign physical object or instrument which is used for diagnostic or therapeutic purposes through a mechanism beyond chemical action. Devices include implantable objects (e.g. pacemakers, stents, artificial joints), medical equipment and supplies (e.g. bandages, crutches, syringes), other instruments used in medical procedures (e.g. sutures, defibrillators) and material used in clinical care (e.g. adhesives, body material, dental material, surgical material).
| Field | Required | Type | Description | 描述 |
|---|---|---|---|---|
| device_exposure_id | Yes | bigint | A system-generated unique identifier for each Device Exposure. | 系統(tǒng)生成的，每個器械暴露的唯一標識符鹿鳖。 |
| person_id | Yes | bigint | A foreign key identifier to the Person who is subjected to the Device. The demographic details of that Person are stored in the PERSON table. | 外鍵扁眯，標識受器械影響的居民。該居民的人口統(tǒng)計信息存儲在PERSON表中翅帜。 |
| device_concept_id | Yes | integer | A foreign key that refers to a Standard Concept identifier in the Standardized Vocabularies belonging to the 'Device' domain. | 外鍵恋拍，指向標準詞匯表中屬于“器械”域的標準概念標識符。 |
| device_exposure_start_date | No | date | The date the Device or supply was applied or used. | 使用器械或耗材的日期藕甩。 |
| device_exposure_start_datetime | Yes | datetime | The date and time the Device or supply was applied or used. | 使用器械或耗材的日期和時間施敢。 |
| device_exposure_end_date | No | date | The date use of the Device or supply was ceased. | 使用器械或耗材的截止日期。 |
| device_exposure_end_datetime | No | datetime | The date and time use of the Device or supply was ceased. | 使用器械或耗材的截止日期和時間狭莱。 |
| device_type_concept_id | Yes | integer | A foreign key to the predefined Concept identifier in the Standardized Vocabularies reflecting the type of Device Exposure recorded. It indicates how the Device Exposure was represented in the source data and belongs to the 'Device Type' domain. | 外鍵僵娃，指向標準詞匯表中預(yù)定義概念，標識記錄的器械暴露類型腋妙。指的是器械暴露信息在源數(shù)據(jù)中的元數(shù)據(jù)字段默怨，屬于“器械類型”域。 |
| unique_device_id | No | varchar(50) | A UDI or equivalent identifying the instance of the Device used in the Person. | 該居民使用的器械相應(yīng)的UDI或其他設(shè)備標識碼骤素。 |
| quantity | No | integer | The number of individual Devices used in the exposure. | 器械暴露的數(shù)量匙睹。（例如X光 3次，或者敷料 2單位） |
| provider_id | No | integer | A foreign key to the provider in the PROVIDER table who initiated or administered the Device. | 外鍵济竹，指向PROVIDER表中記錄的執(zhí)行或者建議執(zhí)行該器械暴露的貢獻者痕檬。（例如開醫(yī)囑的醫(yī)生或者拍片的技師） |
| visit_occurrence_id | No | integer | A foreign key to the visit in the VISIT_OCCURRENCE table during which the Device was used. | 外鍵，指向VISIT_OCCURRENCE表中送浊，該次器械暴露對應(yīng)的就診信息梦谜。 |
| visit_detail_id | No | integer | A foreign key to the visit detail record in the VISIT_DETAIL table during which the Device was used. | 外鍵，指向VISIT_DETAIL中袭景，該次器械暴露對應(yīng)的就診信息唁桩。 |
| device_source_value | No | varchar(50) | The source code for the Device as it appears in the source data. This code is mapped to a Standard Device Concept in the Standardized Vocabularies and the original code is stored here for reference. | 在源數(shù)據(jù)中記錄的器械的源代碼。此代碼已映射到標準化詞匯表中的標準器械概念耸棒，原始代碼存儲在此處以供參考荒澡。 |
| device_source_concept_id | Yes | integer | A foreign key to a Device Concept that refers to the code used in the source. | 外鍵，指向源數(shù)據(jù)中標識器械概念的代碼与殃。 |
共識
| No. | Convention Description | 共識 |
|---|---|---|
| 1 | The distinction between Devices or supplies and Procedures are sometimes blurry, but the former are physical objects while the latter are actions, often to apply a Device or supply. | 器械耗材與操作之間的區(qū)別有時是模糊的单山，但前者是物理對象捏肢，而后者是動作行為，通常是使用器械或耗材饥侵。 |
| 2 | For medical devices that are regulated by the FDA, a Unique Device Identification (UDI) is provided if available in the data source and is recorded in the UNIQUE_DEVICE_ID field. | 對于受FDA監(jiān)管的醫(yī)療器械鸵赫，如果在數(shù)據(jù)源中可用，則提供唯一器械標識（UDI）躏升，并記錄在UNIQUE_DEVICE_ID字段中辩棒。 |
| 3 | Valid Device Concepts belong to the 'Device' domain. The Concepts of this domain are derived from the DI portion of a UDI or based on other source vocabularies, like HCPCS. | “器械”域的概念對記錄器械是有效的。該域的概念源自UDI的DI部分或基于其他源詞匯表膨疏，如HCPCS一睁。 |
| 4 | A Device Type is assigned to each Device Exposure to track from what source the information was drawn or inferred. The valid vocabulary for these Concepts is 'Device Type'. | 為每個器械暴露分配器械類型，以跟蹤從哪個源數(shù)據(jù)采集的信息以及推斷信息的隱含概念佃却≌哂酰“器械類型”是這些概念的有效詞匯。 |
| 5 | The Visit during which the Device was first used is recorded through a reference to the VISIT_OCCURRENCE table. | 通過對VISIT_OCCURRENCE表關(guān)聯(lián)饲帅，來記錄首次使用該器械的就診信息复凳。 |
| 6 | The Visit Detail during which the Device was first used is recorded through a reference to the VISIT_DETAIL table. | 通過對VISIT_DETAIL表關(guān)聯(lián)，來記錄首次使用該器械的就診詳細信息灶泵。 |
| 7 | The Provider exposing the patient to the Device is recorded through a reference to the PROVIDER table. | 通過對PROVIDER表關(guān)聯(lián)育八，來記錄執(zhí)行或推薦執(zhí)行該器械暴露的貢獻者。 |
| 8 | When dealing with duplicate records, the ETL must determine whether to sum them up into one record or keep them separate. Things to consider are:Same Device/ProcedureSame DEVICE_EXPOSURE_START_DATETIMESame Visit Occurrence or Visit DetailSame ProviderSame Modifier for ProceduresSame COST_IDTHEMIS issue #27 | ETL時赦邻，必須確定是將重復(fù)記錄處理合并為一條記錄髓棋，還是將它們分開。需要考慮的事項是：相同的器械/操作惶洲，相同的DEVICE_EXPOSURE_START_DATETIME按声，相同的就診事件，相同的就診詳細信息恬吕，相同的貢獻者签则，相同的操作限定詞，相同的費用ID主題＃27 |
| 9 | If a Device Exposure has a quantity of '0' in the source, this should default to '1' in the ETL. If there is a record in the source it can be assumed the exposure occurred at least once (THEMIS issue #26). | 如果器械暴露在源數(shù)據(jù)中的數(shù)量為“0”币呵，則ETL中默認處理為“1”怀愧。如果源數(shù)據(jù)中有任何該器械記錄，則可以假設(shè)該器械至少暴露過1次（THEMIS問題＃26) |
本系列在介紹目前世界上最適用于臨床科研+衛(wèi)生經(jīng)濟學(xué)的標準醫(yī)療大數(shù)據(jù)格式（未經(jīng)嚴謹考證余赢，但有相關(guān)研究發(fā)表在專業(yè)期刊上），儼然是真實世界研究方案里面最接進成熟的基礎(chǔ)建設(shè)方案哈垢。感興趣的介紹請移步B站觀看視頻妻柒。
OHDSI——觀察性健康醫(yī)療數(shù)據(jù)科學(xué)與信息學(xué)，是一個世界性的公益型非盈利研究聯(lián)盟耘分，主要研究全方位醫(yī)學(xué)大數(shù)據(jù)分析的開源解決方案举塔，旨在通過大規(guī)模數(shù)據(jù)分析和挖掘來提升臨床醫(yī)學(xué)數(shù)據(jù)價值绑警，實現(xiàn)跨學(xué)科、跨行業(yè)的多方合作央渣。目前计盒，目前，已有來自美國芽丹、加拿大北启、澳大利亞、英國等幾十個國家地區(qū)的上百個組織機構(gòu)拔第，高校咕村，醫(yī)院和公司企業(yè)參與了OHDSI全球協(xié)作網(wǎng)絡(luò)，如斯坦福蚊俺、哈佛懈涛、杜克大學(xué)醫(yī)學(xué)院，強生泳猬、諾華批钠、甲骨文、IBM公司得封，擁有超過6億人口的臨床數(shù)據(jù)規(guī)模价匠，累計協(xié)作研究發(fā)表了上百篇論文。
我們在這里邀請國內(nèi)對相關(guān)工作感興趣呛每、愿共同學(xué)習(xí)的好學(xué)人士參與到中文興趣小組踩窖，互通有無，一起彌補跨行業(yè)晨横、跨學(xué)科的知識積累洋腮。前期主要以對OHDSI在github上的開源工作進行翻譯、交流手形、學(xué)習(xí)為主啥供，并會對醫(yī)療大數(shù)據(jù)、醫(yī)學(xué)統(tǒng)計學(xué)库糠、生物信息學(xué)等學(xué)科知識建立學(xué)習(xí)互助伙狐、互督的機制。有興趣的請看文檔瞬欧，微信群二維碼在內(nèi)：OHDSI中文興趣小組共識&OHDSI介紹
OHDSI秉持開源贷屎、開放的宗旨，加快全球醫(yī)學(xué)數(shù)據(jù)研究的步伐艘虎，本文內(nèi)容原創(chuàng)來自Github（https://github.com/OHDSI/CommonDataModel/wiki）唉侄，若有利益沖突，請在本頁面留言野建，真-侵刪属划。
