（健康）狀況是指居民出現(xiàn)疾病、處于某種健康狀態(tài)，例如診斷、癥狀、體征、綜合征，被居民或者貢獻(xiàn)者觀察、記錄。這些健康狀況可能通過不同的術(shù)語、標(biāo)準(zhǔn)記錄下來，例如：
- 醫(yī)療索賠數(shù)據(jù)包括在源詞匯表中編碼的診斷，如ICD-9-CM，作為醫(yī)療服務(wù)報(bào)銷索賠的一部分記錄此類信息
- EHR可以通過診斷、癥狀代碼的形式記錄居民狀況
Conditions are records of a Person suggesting the presence of a disease or medical condition stated as a diagnosis, a sign, or a symptom, which is either observed by a Provider or reported by the patient. Conditions are recorded in different sources and levels of standardization, for example:
- Medical claims data include diagnoses coded in Source Vocabularies such as ICD-9-CM that are submitted as part of a reimbursement claim for health services
- EHRs may capture Person conditions in the form of diagnosis codes or symptoms
| Field | 命名 | Required | Type | Description | 描述 |
|---|---|---|---|---|---|
| condition_occurrence_id | 狀態(tài)-ID | Yes | bigint | A unique identifier for each Condition Occurrence event. | 每個(gè)Condition Occurrence事件的唯一標(biāo)識符。 |
| person_id | 居民-ID | Yes | bigint | A foreign key identifier to the Person who is experiencing the condition. The demographic details of that Person are stored in the PERSON table. | 外鍵，處于該狀態(tài)的居民的標(biāo)識符。該居民的人口統(tǒng)計(jì)學(xué)詳細(xì)信息存儲(chǔ)在PERSON表中。 |
| condition_concept_id | 狀態(tài)-概念-ID | Yes | integer | A foreign key that refers to a Standard Concept identifier in the Standardized Vocabularies belonging to the 'Condition' domain. | 外鍵，指向標(biāo)準(zhǔn)化基礎(chǔ)概念字典庫中的"狀態(tài)"類。 |
| condition_start_date | 狀態(tài)-開始-日期 | No | date | The date when the instance of the Condition is recorded. | 記錄條件實(shí)例的日期。 |
| condition_start_datetime | 狀態(tài)-開始-日期時(shí)間 | Yes | datetime | The date and time when the instance of the Condition is recorded. | 記錄條件實(shí)例的日期和時(shí)間。 |
| condition_end_date | 狀態(tài)-結(jié)束-日期 | No | date | The date when the instance of the Condition is considered to have ended. | 條件實(shí)例的日期被視為已結(jié)束的日期。 |
| condition_end_datetime | 狀態(tài)-結(jié)束-日期時(shí)間 | No | datetime | The date when the instance of the Condition is considered to have ended. | 條件實(shí)例的日期被視為已結(jié)束的日期。 |
| condition_type_concept_id | 狀態(tài)-類型-概念-標(biāo)識符 | Yes | integer | A foreign key to the predefined Concept identifier in the Standardized Vocabularies reflecting the source data from which the Condition was recorded, the level of standardization, and the type of occurrence. These belong to the 'Condition Type' vocabulary | 外鍵，標(biāo)準(zhǔn)詞匯表中預(yù)定義概念標(biāo)識符的，反映源數(shù)據(jù)中記錄狀態(tài)的數(shù)據(jù)、標(biāo)準(zhǔn)化級別和發(fā)生類型。這些屬于“狀態(tài)類型”詞匯表 |
| condition_status_concept_id | 狀態(tài)-性質(zhì)-概念-ID | Yes | integer | A foreign key that refers to a Standard Concept identifier in the Standardized Vocabularies reflecting the point of care at which the Condition was diagnosed. | 外鍵，指標(biāo)準(zhǔn)詞匯表中的標(biāo)準(zhǔn)概念標(biāo)識符，反映診斷條件的護(hù)理點(diǎn)。？ |
| stop_reason | 結(jié)束-原因 | No | varchar(20) | The reason that the Condition was no longer present, as indicated in the source data. | 從源數(shù)據(jù)中信息得出的，狀態(tài)不再存在的原因。 |
| provider_id | 貢獻(xiàn)者-ID | No | integer | A foreign key to the Provider in the PROVIDER table who was responsible for capturing (diagnosing) the Condition. | 外鍵，PROVIDER表中Provider，提供診斷狀態(tài)信息的貢獻(xiàn)者 |
| visit_occurrence_id | 就診-發(fā)現(xiàn)-ID | No | integer | A foreign key to the visit in the VISIT_OCCURRENCE table during which the Condition was determined (diagnosed). | 外鍵，指向在VISIT_OCCURRENCE表中visit，確定（診斷）狀態(tài)的就診時(shí)期。 |
| visit_detail_id | 就診-詳情-ID | No | integer | A foreign key to the visit in the VISIT_DETAIL table during which the Condition was determined (diagnosed). | 外鍵，指向VISIT_DETAIL表中的visit，確定（診斷）狀態(tài)的就診時(shí)期。 |
| condition_source_value | 狀態(tài)-源-值 | No | varchar(50) | The source code for the Condition as it appears in the source data. This code is mapped to a Standard Condition Concept in the Standardized Vocabularies and the original code is stored here for reference. | 狀態(tài)的源代碼，它出現(xiàn)在源數(shù)據(jù)中。此代碼已被映射到標(biāo)準(zhǔn)化詞匯表中標(biāo)準(zhǔn)的狀態(tài)概念，原始代碼存儲(chǔ)在此處以供參考。 |
| condition_source_concept_id | 狀態(tài)-源-概念-ID | Yes | integer | A foreign key to a Condition Concept that refers to the code used in the source. | 外鍵，狀態(tài)概念的外鍵，指向數(shù)據(jù)源中使用的代碼。 |
| condition_status_source_value | 狀態(tài)-性質(zhì)-源-值 | No | varchar(50) | The source code for the condition status as it appears in the source data. This code is mapped to a Standard Concept in the Standardized Vocabularies and the original code is stored here for reference. | 條件狀態(tài)的源代碼，顯示在源數(shù)據(jù)中。此代碼映射到標(biāo)準(zhǔn)化詞匯表中的標(biāo)準(zhǔn)概念，原始代碼存儲(chǔ)在此處以供參考。 |
共識
| No. | Convention Description | 共識 |
|---|---|---|
| 1 | Valid Condition Concepts belong to the 'Condition' domain. | 有效狀態(tài)概念屬于“狀態(tài)”類。 |
| 2 | Condition records are typically inferred from diagnostic codes recorded in the source data. Such code systems, like ICD-9-CM, ICD-10-CM, Read etc., provide a comprehensive coverage of conditions. However, if the diagnostic code in the source does not define a condition, but rather an observation or a procedure, then such information is not stored in the CONDITION_OCCURRENCE table, but in the respective tables indicated by the domain. | 通常根據(jù)源數(shù)據(jù)中記錄的診斷代碼推斷狀態(tài)數(shù)據(jù)。這些術(shù)語系統(tǒng)，如ICD-9-CM，ICD-10-CM，Read等，提供全面的狀態(tài)術(shù)語。但是，如果數(shù)據(jù)源中的診斷代碼不是定義狀態(tài)，而是定義的觀察項(xiàng)目或操作項(xiàng)目，則此類信息不會(huì)存儲(chǔ)在CONDITION_OCCURRENCE表中，而是存儲(chǔ)在“類別”標(biāo)識的相應(yīng)表中。 |
| 3 | Source Condition identifiers are mapped to Standard Concepts for Conditions in the Standardized Vocabularies. When the source code cannot be translated into a Standard Concept, a CONDITION_OCCURRENCE entry is stored with only the corresponding SOURCE_CONCEPT_ID and SOURCE_VALUE, while the CONDITION_CONCEPT_ID is set to 0. | 數(shù)據(jù)源的狀態(tài)ID符映射到標(biāo)準(zhǔn)狀態(tài)詞典的標(biāo)準(zhǔn)狀態(tài)概念。若數(shù)據(jù)源代碼無法轉(zhuǎn)換為標(biāo)準(zhǔn)概念時(shí)，CONDITION_OCCURRENCE條目僅存儲(chǔ)相應(yīng)的SOURCE_CONCEPT_ID和SOURCE_VALUE，而CONDITION_CONCEPT_ID設(shè)為0。 |
| 4 | Family history and past diagnoses ('history of') are not recorded in the CONDITION_OCCURRENCE table. Instead, they are listed in the OBSERVATION table. | 家族史和既往診斷（“歷史記錄”）未記錄在CONDITION_OCCURRENCE表中。相反，它們列在OBSERVATION表中。 |
| 5 | Codes written in the process of establishing the diagnosis, such as 'question of' of and 'rule out', are not represented here. Instead, they are listed in the OBSERVATION table, if they are used for analyses. | 在建立診斷過程中編寫的代碼，例如“疑似”和“排除”，此處未表示。相反，如果它們曾用于分析，則會(huì)列在OBSERVATION表中。 |
| 6 | A Condition Occurrence Type is assigned based on the data source and type of condition attribute, for example:ICD-9-CM Primary Diagnosis from inpatient and outpatient claimsICD-9-CM Secondary Diagnoses from inpatient and outpatient claimsDiagnoses or problems recorded in an EHR. | 狀態(tài)類型的區(qū)分基于數(shù)據(jù)源和狀態(tài)屬性，例如：住院和門診索賠的ICD-9-CM主要診斷、其他診斷，EHR中記錄的診斷或病情。 |
| 7 | Valid Condition Occurrence Type Concepts belong to the 'Condition Type' vocabulary in the 'Type Concept' domain. | 有效狀態(tài)類型的概念屬于“概念類型”中的“狀態(tài)類型”詞匯表。 |
| 8 | The Stop Reason indicates why a Condition is no longer valid with respect to the purpose within the source data. Typical values include 'Discharged', 'Resolved', etc. Note that a Stop Reason does not necessarily imply that the condition is no longer occurring. | 狀態(tài)結(jié)束原因表示源數(shù)據(jù)中不再有該狀態(tài)的有效數(shù)據(jù)的原因。典型值包括'Discharged'，'Resolved'等。請注意，Stop Reason并不一定意味著該狀態(tài)不再發(fā)生。 |
| 9 | Condition source codes are typically ICD-9-CM, Read or ICD-10-CM diagnosis codes from medical claims or discharge status/visit diagnosis codes from EHRs. | 狀態(tài)源代碼通常是來自醫(yī)療索賠的ICD-9-CM，read或ICD-10-CM診斷代碼，或來自EHR的出院記錄/就診診斷。 |
| 10 | Presently, there is no designated vocabulary, domain, or class that represents condition status. The following concepts from SNOMED are recommended:Admitting diagnosis: 4203942Final diagnosis: 4230359 (should also be used for discharge diagnosisPreliminary diagnosis: 4033240 | 目前，沒有表達(dá)狀態(tài)性質(zhì)的指定詞匯、類、別。建議使用SNOMED的如下概念：入院診斷：4203942，確診診斷：4230359（也應(yīng)用于出院診斷），初步診斷：4033240 |
本系列在介紹目前世界上最適用于臨床科研+衛(wèi)生經(jīng)濟(jì)學(xué)的標(biāo)準(zhǔn)醫(yī)療大數(shù)據(jù)格式（未經(jīng)嚴(yán)謹(jǐn)考證，但有相關(guān)研究發(fā)表在專業(yè)期刊上），儼然是真實(shí)世界研究方案里面最接進(jìn)成熟的基礎(chǔ)建設(shè)方案。感興趣的介紹請移步B站觀看視頻。
OHDSI——觀察性健康醫(yī)療數(shù)據(jù)科學(xué)與信息學(xué)，是一個(gè)世界性的公益型非盈利研究聯(lián)盟，主要研究全方位醫(yī)學(xué)大數(shù)據(jù)分析的開源解決方案，旨在通過大規(guī)模數(shù)據(jù)分析和挖掘來提升臨床醫(yī)學(xué)數(shù)據(jù)價(jià)值，實(shí)現(xiàn)跨學(xué)科、跨行業(yè)的多方合作。目前，目前，已有來自美國、加拿大、澳大利亞、英國等幾十個(gè)國家地區(qū)的上百個(gè)組織機(jī)構(gòu)，高校，醫(yī)院和公司企業(yè)參與了OHDSI全球協(xié)作網(wǎng)絡(luò)，如斯坦福、哈佛、杜克大學(xué)醫(yī)學(xué)院，強(qiáng)生、諾華、甲骨文、IBM公司，擁有超過6億人口的臨床數(shù)據(jù)規(guī)模，累計(jì)協(xié)作研究發(fā)表了上百篇論文。
我們在這里邀請國內(nèi)對相關(guān)工作感興趣、愿共同學(xué)習(xí)的好學(xué)人士參與到中文興趣小組，互通有無，一起彌補(bǔ)跨行業(yè)、跨學(xué)科的知識積累。前期主要以對OHDSI在github上的開源工作進(jìn)行翻譯、交流、學(xué)習(xí)為主，并會(huì)對醫(yī)療大數(shù)據(jù)、醫(yī)學(xué)統(tǒng)計(jì)學(xué)、生物信息學(xué)等學(xué)科知識建立學(xué)習(xí)互助、互督的機(jī)制。有興趣的請看文檔，微信群二維碼在內(nèi)：OHDSI中文興趣小組共識&OHDSI介紹
OHDSI秉持開源、開放的宗旨，加快全球醫(yī)學(xué)數(shù)據(jù)研究的步伐，本文內(nèi)容原創(chuàng)來自Github（https://github.com/OHDSI/CommonDataModel/wiki），若有利益沖突，請?jiān)诒卷撁媪粞?，?侵刪。
