Namespaces

Variants
Actions
Personal tools

PheDRS

From UABgrid Documentation

(Difference between revisions)
Jump to: navigation, search
(Creation)
 
(CVTERM Prop configuration added)
Line 2: Line 2:
  
 
The Phenotype Detection Registry System (PheDRS) is a tool at UAB used to assist researchers and clinicians identify populations of interest at UAB matching clinical criteria from both structured data (billing codes, medications, labs) and unstructured documents using Natural Language Processing.
 
The Phenotype Detection Registry System (PheDRS) is a tool at UAB used to assist researchers and clinicians identify populations of interest at UAB matching clinical criteria from both structured data (billing codes, medications, labs) and unstructured documents using Natural Language Processing.
 +
 +
== Registry Configuration ==
 +
{| class="wikitable"
 +
|+ Registry Configuration: Cvtermprop parameters
 +
|-
 +
! CV NAME
 +
! CV ID
 +
! Example of cvterm name for TYPE_ID
 +
! Meaning and Use of VALUE field for this type
 +
! Example of Value Field
 +
|-
 +
| UAB ICD-10-CM Codes
 +
| 9
 +
| Panlobular emphysema
 +
| If patient has this billing code, assign as candidate to registry
 +
| UAB COPD Registry ICD-10-CM diagnosis criteria
 +
 +
|-
 +
| UAB MS DRG Codes
 +
| 12
 +
| COPD w CC
 +
| If patient has this DRG code, then add anchor cvterm property to this code
 +
| DRG Codes COPD Anchor Encounter criteria
 +
 +
|-
 +
|
 +
|
 +
| COPD w MCC
 +
| If patient has this DRG code, then add patient to the registry as "accepted"
 +
| UAB COPD Registry DRG Codes inclusion criteria
 +
 +
|-
 +
| PHEDRS Data Loading Criteria
 +
| 23
 +
| Default NLP Pipeline Collection
 +
| This is the ID# of the default pipeline for displaying documents in this registry. Unenforced Foreign Key to db_id=14
 +
| 2
 +
 +
|-
 +
|
 +
|
 +
| Encounter Collection
 +
| Encounters matching the appended SQL criteria are added to the registry
 +
|  AND (SRC_ADMIT_DT_TM >= (SYSDATE-730)) AND FORMATTED_MEDICAL_RECORD_NBR IN (SELECT FORMATTED_UAB_MRN FROM REGISTRY_PATIENT WHERE REGISTRY_ID=2861)
 +
 +
 +
|-
 +
|
 +
|
 +
| Encounter Intervention
 +
| Encounters matching the appended SQL criteria are added to the registry AND candidate is flagged for review
 +
| AND SRC_ADMIT_DT_TM >= (SYSDATE-30) AND (  (reason_for_visit_txt LIKE '%COPD%') OR (UPPER(reason_for_visit_txt) LIKE '%BRONCHITIS%') OR (UPPER(reason_for_visit_txt) LIKE '%BRONCHIECTASIS%') OR (UPPER(reason_for_visit_txt) LIKE '%EMPHYSEMA%')  )
 +
 +
|-
 +
| PHEDRS MetaData CV
 +
| 24
 +
| Patient Review Cutoff Date
 +
| Do not retrieve any data (codes, encounters, documents) from source system before this date
 +
| 1/1/17
 +
 +
|-
 +
|
 +
|
 +
| Registry Application Title
 +
| Use this text here for the name of the registry
 +
| COPD Registry Control Panel
 +
 +
|-
 +
|
 +
|
 +
| Display Codes Database Identifier
 +
| DB_ID permissable to display in "Diagnoses and Drgs" Panel
 +
| 8
 +
 +
|-
 +
| PHEDRS Tab CV
 +
| 25
 +
| REGISTRY_INPATIENT_REVIEW
 +
| Indicates that this tab should be displayed in this registry. Value indicates display order from LEFT to RIGHT (1 for leftmost tab)
 +
| 1
 +
 +
|-
 +
| Optum UAB APR DRG Codes 2017
 +
| 26
 +
|
 +
|
 +
|
 +
 +
|-
 +
| UAB WH CLN REF Codeset 69
 +
| 27
 +
|
 +
|
 +
|
 +
 +
 +
|}

Revision as of 16:25, 14 January 2019

Phenotype Detection Registry System

The Phenotype Detection Registry System (PheDRS) is a tool at UAB used to assist researchers and clinicians identify populations of interest at UAB matching clinical criteria from both structured data (billing codes, medications, labs) and unstructured documents using Natural Language Processing.

Registry Configuration

Registry Configuration: Cvtermprop parameters
CV NAME CV ID Example of cvterm name for TYPE_ID Meaning and Use of VALUE field for this type Example of Value Field
UAB ICD-10-CM Codes 9 Panlobular emphysema If patient has this billing code, assign as candidate to registry UAB COPD Registry ICD-10-CM diagnosis criteria
UAB MS DRG Codes 12 COPD w CC If patient has this DRG code, then add anchor cvterm property to this code DRG Codes COPD Anchor Encounter criteria
COPD w MCC If patient has this DRG code, then add patient to the registry as "accepted" UAB COPD Registry DRG Codes inclusion criteria
PHEDRS Data Loading Criteria 23 Default NLP Pipeline Collection This is the ID# of the default pipeline for displaying documents in this registry. Unenforced Foreign Key to db_id=14 2
Encounter Collection Encounters matching the appended SQL criteria are added to the registry AND (SRC_ADMIT_DT_TM >= (SYSDATE-730)) AND FORMATTED_MEDICAL_RECORD_NBR IN (SELECT FORMATTED_UAB_MRN FROM REGISTRY_PATIENT WHERE REGISTRY_ID=2861)


Encounter Intervention Encounters matching the appended SQL criteria are added to the registry AND candidate is flagged for review AND SRC_ADMIT_DT_TM >= (SYSDATE-30) AND ( (reason_for_visit_txt LIKE '%COPD%') OR (UPPER(reason_for_visit_txt) LIKE '%BRONCHITIS%') OR (UPPER(reason_for_visit_txt) LIKE '%BRONCHIECTASIS%') OR (UPPER(reason_for_visit_txt) LIKE '%EMPHYSEMA%') )
PHEDRS MetaData CV 24 Patient Review Cutoff Date Do not retrieve any data (codes, encounters, documents) from source system before this date 1/1/17
Registry Application Title Use this text here for the name of the registry COPD Registry Control Panel
Display Codes Database Identifier DB_ID permissable to display in "Diagnoses and Drgs" Panel 8
PHEDRS Tab CV 25 REGISTRY_INPATIENT_REVIEW Indicates that this tab should be displayed in this registry. Value indicates display order from LEFT to RIGHT (1 for leftmost tab) 1
Optum UAB APR DRG Codes 2017 26
UAB WH CLN REF Codeset 69 27