PROCEDURE_OCCURRENCE表
2020-04-15 本文已影响0人
skysunky
PROCEDURE_OCCURRENCE表，包含为了诊断或治疗目的，由医疗保健服务贡献者开医嘱或直接执行医疗行为操作的记录。操作以不同形式存在于各种源数据中，具有不同的标准化水平。例如：
- 医疗理赔，索赔数据中医疗服务索赔的一部分数据是操作代码。
- 电子健康记录，医嘱里包含操作信息。
The PROCEDURE_OCCURRENCE table contains records of activities or processes ordered by, or carried out by, a healthcare provider on the patient to have a diagnostic or therapeutic purpose. Procedures are present in various data sources in different forms with varying levels of standardization. For example:
- Medical Claims include procedure codes that are submitted as part of a claim for health services rendered, including procedures performed.
- Electronic Health Records that capture procedures as orders.
| Field | Required | Type | Description | 描述 |
|---|---|---|---|---|
| procedure_occurrence_id | Yes | integer | A system-generated unique identifier for each Procedure Occurrence. | 系统生成的每个操作的唯一标识符。 |
| person_id | Yes | integer | A foreign key identifier to the Person who is subjected to the Procedure. The demographic details of that Person are stored in the PERSON table. | 外键，标识接受操作的居民。该居民的人口统计信息存储在PERSON表中。 |
| procedure_concept_id | Yes | integer | A foreign key that refers to a standard procedure Concept identifier in the Standardized Vocabularies. | 外键，指向标准词汇表中的操作的标准概念。 |
| procedure_date | No | date | The date on which the Procedure was performed. | 操作执行的日期。 |
| procedure_datetime | Yes | datetime | The date and time on which the Procedure was performed. | 操作执行的日期和时间。 |
| procedure_type_concept_id | Yes | integer | A foreign key to the predefined Concept identifier in the Standardized Vocabularies reflecting the type of source data from which the procedure record is derived, belonging to the 'Procedure Type' vocabulary. | 外键，标准词汇表中预定义概念标识符，标识从中派生操作记录的源数据类型，属于“操作类型”词汇表。 |
| modifier_concept_id | Yes | integer | A foreign key to a Standard Concept identifier for a modifier to the Procedure (e.g. bilateral). These concepts are typically distinguished by 'Modifier' concept classes (e.g., 'CPT4 Modifier' as part of the 'CPT4' vocabulary). | 外键，标准概念标识符，用于操作的限定词（例如双侧）。这些概念通常通过“限定词”概念类来区分（例如，'CPT4限定词'作为'CPT4'词汇表的一部分）。 |
| quantity | No | integer | The quantity of procedures ordered or administered. | 医嘱中或治疗方案中的操作数量。 |
| provider_id | No | integer | A foreign key to the provider in the PROVIDER table who was responsible for carrying out the procedure. | 外键，标识PROVIDER表中记录的负责执行该操作的贡献者 |
| visit_occurrence_id | No | integer | A foreign key to the Visit in the VISIT_OCCURRENCE table during which the Procedure was carried out. | 外键，标识操作执行对应的VISIT_OCCURRENCE表中对应的就诊信息 |
| visit_detail_id | No | integer | A foreign key to the Visit Detail in the VISIT_DETAIL table during which the Procedure was carried out. | 外键，标识操作执行对应的VISIT_DETAIL表中对应的就诊详细信息 |
| procedure_source_value | No | varchar(50) | The source code for the Procedure as it appears in the source data. This code is mapped to a standard procedure Concept in the Standardized Vocabularies and the original code is, stored here for reference. Procedure source codes are typically ICD-9-Proc, CPT-4, HCPCS or OPCS-4 codes. | 出现在源数据中对应操作的源代码。此代码映射到标准化词汇表中的标准操作概念，原始代码存储在此处以供参考。操作的源代码通常是ICD-9-Proc，CPT-4，HCPCS或OPCS-4代码。 |
| procedure_source_concept_id | Yes | integer | A foreign key to a Procedure Concept that refers to the code used in the source. | 外键，源数据中标识标识操作概念的代码。 |
| modifier_source_value | No | varchar(50) | The source code for the qualifier as it appears in the source data. | 源数据中限定符的源代码 |
共识
| No. | Convention Description | 共识 |
|---|---|---|
| 1 | Valid Procedure Concepts belong to the 'Procedure' domain. Procedure Concepts are based on a variety of vocabularies: SNOMED-CT, ICD-9-Proc, CPT-4, HCPCS and OPCS-4, but also atypical Vocabularies such as ICD-9-CM or MedDRA. | 对于操作，“Procedure”域是有效概念。操作概念基于各种术语集：SNOMED-CT，ICD-9-Proc，CPT-4，HCPCS和OPCS-4，以及非典型词汇表，如ICD-9-CM或MedDRA。 |
| 2 | Procedures are expected to be carried out within one day and therefore have no end date. | 预设每一种操作都在一天内进行，因此没有结束日期。 |
| 3 | Procedures could involve the application of a drug, in which case the procedural component is recorded in the procedure table and simultaneously the administered drug in the drug exposure table when both the procedural component and drug are identifiable. | 操作可能涉及药物的应用，在这种情况下，当操作和药物都可识别时，操作部分信息记录在PROCEDURE表中，同时，药物暴露的信息记录在DRUG_EXPOSURE表。 |
| 4 | If the quantity value is omitted, a single procedure is assumed. | 如果省略了数量值不记录，那么认定该操作为1次。 |
| 5 | The Procedure Type defines from where the Procedure Occurrence is drawn or inferred. For administrative claims records the type indicates whether a Procedure was primary or secondary and their relative positioning within a claim. | 操作类型，表示的是从何处抓取或推断的该操作数据。例如对于理赔记录，操作类型指的是主要理赔项目或次要理赔项目。 |
| 6 | The Visit during which the procedure was performed is recorded through a reference to the VISIT_OCCURRENCE table. This information is not always available. | 通过关联VISIT_OCCURRENCE表，可记录执行该次操作对应的就诊信息。此信息并非始终可用。 |
| 7 | The Visit Detail during with the procedure was performed is recorded through a reference to the VISIT_DETAIL table. This information is not always available. | 通过关联VISIT_DETAIL表，可记录执行该次操作对应的就诊详细信息。此信息并非始终可用。 |
| 8 | The Provider carrying out the procedure is recorded through a reference to the PROVIDER table. This information is not always available. | 通过关联PROVIDER表，可记录执行该次操作对应的贡献者信息（执行人，如主刀，执行护士，执行医师，报告技师等）。此信息并非始终可用。 |
| 9 | [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 ProcedureSame PROCEDURE_DATETIMESame Visit Occurrence or Visit DetailSame ProviderSame Modifier for ProceduresSame COST_IDTHEMIS issue #27 | ETL中，必须确定是将重复记录合并为一条记录还是将它们分开。需要考虑的事项是：相同的操作，相同的操作日期时间，相同的就诊事件或就诊详细信息，相同的操作贡献者，相同的操作限定词，相同的费用IDTHEMIS issue#27 |
| 10 | If a Procedure 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). | 如果数据源中的操作数量为“0”，则ETL处理时的值应为“1”。如果数据源中有任何操作相关的记录，则可以假定为该操作暴露至少发生过一次（THEMIS问题＃26） |
本系列在介绍目前世界上最适用于临床科研+卫生经济学的标准医疗大数据格式（未经严谨考证，但有相关研究发表在专业期刊上），俨然是真实世界研究方案里面最接进成熟的基础建设方案。感兴趣的介绍请移步B站观看视频。
OHDSI——观察性健康医疗数据科学与信息学，是一个世界性的公益型非盈利研究联盟，主要研究全方位医学大数据分析的开源解决方案，旨在通过大规模数据分析和挖掘来提升临床医学数据价值，实现跨学科、跨行业的多方合作。目前，目前，已有来自美国、加拿大、澳大利亚、英国等几十个国家地区的上百个组织机构，高校，医院和公司企业参与了OHDSI全球协作网络，如斯坦福、哈佛、杜克大学医学院，强生、诺华、甲骨文、IBM公司，拥有超过6亿人口的临床数据规模，累计协作研究发表了上百篇论文。
我们在这里邀请国内对相关工作感兴趣、愿共同学习的好学人士参与到中文兴趣小组，互通有无，一起弥补跨行业、跨学科的知识积累。前期主要以对OHDSI在github上的开源工作进行翻译、交流、学习为主，并会对医疗大数据、医学统计学、生物信息学等学科知识建立学习互助、互督的机制。有兴趣的请看文档，微信群二维码在内：OHDSI中文兴趣小组共识&OHDSI介绍
OHDSI秉持开源、开放的宗旨，加快全球医学数据研究的步伐，本文内容原创来自Github（https://github.com/OHDSI/CommonDataModel/wiki），若有利益冲突，请在本页面留言，真-侵删。
