| Atomic Warehouse Model Data Model |
| Description | This entity contains medication related attributes which reflect the data output from a Natural Language Processing Annotator. |
| Dependencies | |
 NONE |
|
| Reverse Dependencies | |
| |
|
| Attribute Details |
Admission Ts
| Description | The admit date/time. It is to be used if the event date/time is different than the admit date and time, i.e., a retroactive update. This field is also used to reflect the date/time of an out-patient/emergency patient registration. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Timestamp [TIMESTAMP] |
| Is Part Of PrimaryKey | false |
| Is Required | true |
| Is Derived | false |
| Is Surrogate Key | false |
Annotator Cd
| Description | A code representing the annotator used to extract the data. For example: Problem Procedure Medication |
| Data Type | Standards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Annotator Version Num
| Description | A number representing the version of the Annotator used to extract the data. eg. Problem or Procedure Code. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Alphanumeric [VARCHAR(80)] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Coding Domain Nm
| Description | A unique name for a group or type of codes. E.g. CPT, ICD, SNOMED, RXNORM. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Domain Name [VARCHAR(30)] |
| Is Part Of PrimaryKey | false |
| Is Required | true |
| Is Derived | false |
| Is Surrogate Key | false |
Coding Version Num
| Description | The designation of a unique set of codes. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Alphanumeric [VARCHAR(80)] |
| Is Part Of PrimaryKey | false |
| Is Required | true |
| Is Derived | false |
| Is Surrogate Key | false |
Confidence Factor Cd
| Description | The Problem confidence factor code describes the nature of problem identification such as: possible rule_out almost at_risk likely negative positive |
| Data Type | Standards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Confidence Factor Val
| Description | Ratio, out of 100, that a problem was correctly discovered in an unstructured document |
| Data Type | Standards - Data Domains.ddm/Data Domains/Rate [FLOAT(5)] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Discharge Ts
| Description | The discharge date/time. It is to be used if the event date/time is different than the discharge date and time, that is, a retroactive update. This field is also used to reflect the date/time of an outpatient/emergency patient discharge. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Timestamp [TIMESTAMP] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Document Content Text
| Description | A representation of the document analyzed by the Annotator in text format. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Text Very Large [VARCHAR(2048)] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Document Location Url
| Description | An URL pointing to the actual content of the message on a document management tool or other remote location. |
| Data Type | Standards - Data Domains.ddm/Data Domains/URL [VARCHAR(255)] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Document Section Cd
| Description | The code identifies the section of a document such as Complaint Medical History Family Medical History Lab Results Physical Examination etc. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Document Span Date
| Description | A date identified in the Span Cover Text. This date is deemed to have a relationship with procedure or problem. E.g Completed Date, Rescheduled Date. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Date Time [TIMESTAMP] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Document Ts
| Description | Timestamp of when the document was created. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Timestamp [TIMESTAMP] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Document Type Cd
| Description | The code indicates the type of document (as defined in the transcription system). Examples include: Autopsy report Cardiodiagnostics Consultation Diagnostic imaging Discharge summary Emergency department report History and physical examination Operative report Psychiatric consultation Psychiatric history and physical examination Procedure note Progress note Surgical pathology Transfer summary |
| Data Type | Standards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Drug Code
| Description | The unique identifier for the drug. E.g. RxNorm Concept ID |
| Data Type | Standards - Data Domains.ddm/Data Domains/Identifier [VARCHAR(80)] |
| Is Part Of PrimaryKey | false |
| Is Required | true |
| Is Derived | false |
| Is Surrogate Key | false |
Drug Dosage
| Description | The dosage of the drug identified in the Span Cover Text. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Alphanumeric [VARCHAR(80)] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Drug Frequency
| Description | The frequency of the drug identified in the Span Cover Text. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Alphanumeric [VARCHAR(80)] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Drug Nm
| Description | The name of the drug identified in the Span Cover Text. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Description Short [VARCHAR(150)] |
| Is Part Of PrimaryKey | false |
| Is Required | true |
| Is Derived | false |
| Is Surrogate Key | false |
Drug Route
| Description | Identifies how the medication is to be taken by the recipient. e.g.: Apply Externally Buccal Dental Intravenous Oral Intra-arterial |
| Data Type | Standards - Data Domains.ddm/Data Domains/Common Code [VARCHAR(80)] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Encounter Num
| Description | An identifier that uniquely defines an encounter. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Alphanumeric [VARCHAR(80)] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Medical Record Num
| Description | The Medical Record Number currently used to identify the patient. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Alphanumeric [VARCHAR(80)] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Provider Organization Master Num
| Description | Universal business identifier for the Organization. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Alphanumeric [VARCHAR(80)] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Responsible Practitioner Identifier Num
| Description | Any unique identifier assigned by provider to the practitioner responsible for the identification of this patient's problem.. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Alphanumeric [VARCHAR(80)] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Span Begin Cnt
| Description | Character count of the location within a document where the span describing the medication begins. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Count [INTEGER] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Span Cover Text
| Description | This is the string of text within an unformatted text document that has been identified by the Natural Language Processing engine as a Span. The Span describes a data type (e.g medication). |
| Data Type | Standards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Span End Cnt
| Description | Character count of the location within a document where the span describing the medication ends. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Count [INTEGER] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
UMPI Num
| Description | Identifies the universal patient identifier set in Master Data Management. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Alphanumeric [VARCHAR(80)] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
| Atomic Warehouse Model Data Model |