|
Name |
Type |
Discontinued? |
|
| 1 |
QUERY_ID |
NUMERIC |
No |
|
|
|
| The unique identifier for the query record. |
|
|
| 2 |
EXTERNAL_IDENTIFIER |
VARCHAR |
No |
|
|
|
| The ID received from a third party to uniquely identify the record in their system. |
|
|
| 3 |
STATUS_C_NAME |
VARCHAR |
No |
|
|
|
| The overall status of the query. |
| May contain organization-specific values: No |
| Category Entries: |
| Active |
| Response Received |
| Completed |
| Deleted |
| Deactivated |
|
|
| 4 |
PAT_ID |
VARCHAR |
No |
|
|
|
| The patient ID the query refers to. |
|
|
| 5 |
PAT_ENC_CSN_ID |
NUMERIC |
No |
|
|
|
| The patient contact (CSN) the query refers to. |
|
|
| 6 |
CREATION_UTC_DTTM |
DATETIME (UTC) |
No |
|
|
|
| The instant the query was created in UTC. |
|
|
| 7 |
UPDATE_UTC_DTTM |
DATETIME (UTC) |
No |
|
|
|
| Stores the instant the query record was updated in UTC. |
|
|
| 8 |
QUERY_WORKFLOW_C_NAME |
VARCHAR |
No |
|
|
|
| The workflow this query is a part of (Computer Assisted Physician Documentation (CAPD), Clinical Documentation Improvement, etc.). This value is used to drive functionality and reporting. |
| May contain organization-specific values: No |
| Category Entries: |
| Coding Query |
| CDI Query |
| Coding Documentation Deficiency |
| CAPD |
| PB Coding Query |
|
|
| 9 |
QRY_HIDE_PHYS_YN |
VARCHAR |
No |
|
|
|
| If this is set to 1-Yes, it will prevent physicians from seeing the query in the NoteReader Clinical Documentation Improvement (CDI) activity. If NoteReader CDI is in silent mode, all incoming queries will have this flag set automatically. CDI users can reset this flag by activating the query manually. |
| May contain organization-specific values: No |
| Category Entries: |
| No |
| Yes |
|
|
| 10 |
RECORD_CREATION_DT |
DATETIME |
No |
|
|
|
| Stores the date the record was created. |
|
|
| 11 |
INSTANT_OF_UPDATE_DTTM |
DATETIME (Local) |
No |
|
|
|
| Stores the instant the record was last locked/unlocked. |
|
|
| 12 |
QUERY_CONDITION_C_NAME |
VARCHAR |
No |
|
|
|
| This item stores the patient's condition that this query is related to. This is determined based on the target diagnosis (QRY-55) or the suggestions (QRY 1150 group). |
| May contain organization-specific values: No |
| Category Entries: |
| Other Condition |
| Acute Myocardial Infarction |
| Anemia |
| Debridement |
| Heart Failure |
| Pneumonia |
| Sepsis |
| Bronchitis |
| Chronic Obstructive Pulmonary Disease |
| Acute Kidney Injury |
| Attention Deficit Hyperactive Disorder |
| Arrhythmia |
| Burn |
| Cerebral Palsy |
| Chronic Kidney Disease |
| Dementia |
| Diabetes |
| Enteric Ulcer |
| Headache |
| Heart Disease |
| Hemorrhoids |
| Hernia |
| Hyperbilirubinemia |
| Hypertension |
| Respiratory Failure |
| Pelvic Inflammatory Disease |
| Phlebitis |
| Rheumatoid Arthritis |
| Stroke |
| Transport Injury |
| Varicose Veins |
| Vehicle Injury |
| Vesicoureteral Reflux |
| Whooping Cough |
| Withdrawal |
| Renal Failure |
| Malnutrition |
| Encephalopathy |
| Asthma |
| Depression |
| Cerebral Infarction |
| Fracture |
| Gastrointestinal Bleed |
| Colitis |
| Surgical Complication |
| Bronchiolitis |
| Syncope |
| Altered Mental Status |
| Pleural Effusion |
| Thrombosis |
| Embolism |
| Rhabdomyolysis |
| Seizure |
| Obesity |
| Pulmonary Embolism |
| Human Immunodeficiency Virus |
| Shock |
| Pancytopenia |
| Cor Pulmonale |
| Deep Vein Thrombosis |
| Atrial Fibrillation |
| Bowel Ischemia |
| Cachexia |
| Catheter Associated UTI |
| Central Line Associated Bloodstream Infection |
| Cerebral Edema |
| Coagulopathy and Coagulation Disorders |
| End Stage Liver Disease |
| Pulmonary Edema |
| Skin Ulcer |
| Systemic Inflammatory Response Syndrome |
| Urosepsis |
| Skin Ulcer |
| COVID-19 |
| Substance Use |
| Developmental Delay |
| Neonatal Drug Exposure |
| Neonatal Maternal Diabetes |
| Neonatal Necrotizing Enterocolitis |
|
|
