| Atomic Warehouse Model Data Model |
| Description | This entity contains problem and procedure 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 representating 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 | The date mentioned in the Span within a document. For example: The patient was diagnosed with diabetes on August 14, 1996. |
| 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 |
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 |
Normalized Descr
| Description | The description of the procedure code or problem code according to the Natural Language Processing Annotator. |
| 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 |
Problem Procedure Cd
| Description | A code that uniquely identifies a Problem or Procedure code within a domain. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Common Code [VARCHAR(80)] |
| Is Part Of PrimaryKey | false |
| Is Required | true |
| 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 problem/procedure 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 problem, procedure). |
| 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 problem/procedure 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 |
Type Ind
| Description | An indication of what type of data was identified by the annotator. E.g Procedure or Problem |
| Data Type | Standards - Data Domains.ddm/Data Domains/Enumeration [VARCHAR(20)] |
| Is Part Of PrimaryKey | false |
| Is Required | true |
| 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 |