Dimensional Warehouse Model Data Model

Entity

Entity Document Dimension

Description

Information about a specific transcribed document that record but does not include the text of the document.

Attributes
Availability Sts Cd
Availability Sts Code Sk
Availability Sts Descr
AWM Load Info Sk
Change Reason Txt
Communication Mode Cd
Communication Mode Code Sk
Communication Mode Descr
Completion Sts Cd
Completion Sts Code Sk
Completion Sts Descr
Confidentiality Sts Cd
Confidentiality Sts Code Sk
Confidentiality Sts Descr
Current Ind
Document Bk
Document Content Presentation Cd
Document Content Presentation Code Sk
Document Content Presentation Descr
Document Content Txt
Document Dk
Document Location
Document Sk
Document Type Cd
Document Type Code Sk
Document Type Descr
Due Dt
DWM Load Info Sk
Effective From Dt
Effective To Dt
Nullification Ind
Nullification Reason Cd
Nullification Reason Code Sk
Nullification Reason Descr
Physician Sign Off Ind
Point Of Care Device Dk
Public Descr
Public Title Txt
Scientific Descr
Source Cd
Source Code Descr
Source Code Sk
Storage Sts Cd
Storage Sts Code Sk
Storage Sts Descr
Sub Type Cd
Sub Type Code Sk
Sub Type Descr
Tenant Sk
Unique Document File Nm
Unique Document Num
Valid From Ts
Valid To Ts

Relationship
Document Dimension_Point Of Care Device Dimension_FK

Primary Key
Document Dimension PK

Dependencies

Reverse Dependencies

Attribute Details

Availability Sts Cd

Description	Identifies a document's availability for use in patient care. For example: Available for patient care Deleted Obsolete Unavailable for patient care
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

Availability Sts Code Sk

Description	Identifies a document's availability for use in patient care. For example: Available for patient care Deleted Obsolete Unavailable for patient care
Data Type	Standards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Availability Sts Descr

Description	Identifies a document's availability for use in patient care. For example: Available for patient care Deleted Obsolete Unavailable for patient care
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

AWM Load Info Sk

Description	The surrogate key of the load information entry describing the details regarding the loading of the row in the atomic data warehouse.
Data Type	Standards - Data Domains.ddm/Data Domains/Surrogate Key Large [LONG]
Is Part Of PrimaryKey	false
Is Required	true
Is Derived	false
Is Surrogate Key	false

Change Reason Txt

Description	Contains the reason for the change in status of the document.
Data Type	Standards - Data Domains.ddm/Data Domains/Text Small [VARCHAR(50)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Communication Mode Cd

Description	Specifies the form in which the report is transmitted. For example: Physically present Over the telephone Written communication Electronic
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

Communication Mode Code Sk

Description	Specifies the form in which the report is transmitted. For example: Physically present Over the telephone Written communication Electronic
Data Type	Standards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Communication Mode Descr

Description	Specifies the form in which the report is transmitted. For example: Physically present Over the telephone Written communication Electronic
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

Completion Sts Cd

Description	Indicates the current completion status of the document. For example: Dictated Documented In Progress Incomplete Pre-authenticated Authenticated Legally authenticated
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

Completion Sts Code Sk

Description	Indicates the current completion status of the document. For example: Dictated Documented In Progress Incomplete Pre-authenticated Authenticated Legally authenticated
Data Type	Standards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Completion Sts Descr

Description	Indicates the current completion status of the document. For example: Dictated Documented In Progress Incomplete Pre-authenticated Authenticated Legally authenticated
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

Confidentiality Sts Cd

Description	Identifies the status of the special confidentiality protection which should be applied to this information. For example: Very restricted Restricted Usual control
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

Confidentiality Sts Code Sk

Description	Identifies the status of the special confidentiality protection which should be applied to this information. For example: Very restricted Restricted Usual control
Data Type	Standards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Confidentiality Sts Descr

Description	Identifies the status of the special confidentiality protection which should be applied to this information. For example: Very restricted Restricted Usual control
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

Current Ind

Description	Set to 'Y' if this is the most recent row of a group having the same Surrogate Key.
Data Type	Standards - Data Domains.ddm/Data Domains/Boolean Indicator [INTEGER]
Is Part Of PrimaryKey	false
Is Required	true
Is Derived	false
Is Surrogate Key	false

Document Bk

Description	Concatenated values of a set of business attributes that uniquely identify the row.
Data Type	Standards - Data Domains.ddm/Data Domains/Business Key [VARCHAR(255)]
Is Part Of PrimaryKey	false
Is Required	true
Is Derived	false
Is Surrogate Key	false

Document Content Presentation Cd

Description	Indicates the method by which this document was obtained or originated.Conditional field which is required whenever the message contains content as presented in one or more observations. For example: Audio data Formatted text Image data Scanned document
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 Content Presentation Code Sk

Description	Indicates the method by which this document was obtained or originated.Conditional field which is required whenever the message contains content as presented in one or more observations. For example: Audio data Formatted text Image data Scanned document
Data Type	Standards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Document Content Presentation Descr

Description	Indicates the method by which this document was obtained or originated.Conditional field which is required whenever the message contains content as presented in one or more observations. For example: Audio data Formatted text Image data Scanned document
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

Document Content Txt

Description	Contains the complete content of the document.
Data Type	Standards - Data Domains.ddm/Data Domains/Text Large [VARCHAR(1024)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Document Dk

Description	A numeric surrogate key used to uniquely identify entities in the dimensional model.
Data Type	Standards - Data Domains.ddm/Data Domains/Surrogate Key Large [LONG]
Is Part Of PrimaryKey	true
Is Required	true
Is Derived	false
Is Surrogate Key	true

Document Location

Description	An address pointing to the location of a referenced document. e.g.:: A URL address
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 Sk

Description	A numeric surrogate key used to uniquely identify entities in the atomic model.
Data Type	Standards - Data Domains.ddm/Data Domains/Surrogate Key Large [LONG]
Is Part Of PrimaryKey	false
Is Required	true
Is Derived	false
Is Surrogate Key	false

Document Type Cd

Description	Classifies the document by its type (as defined in the transcription system). For example: 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

Document Type Code Sk

Description	Classifies the document by its type (as defined in the transcription system). For example: 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/Surrogate Key [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Document Type Descr

Description	Classifies the document by its type (as defined in the transcription system). For example: 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/Description [VARCHAR(250)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Due Dt

Description	The date and time on which the report is expected or scheduled to be submitted.
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

DWM Load Info Sk

Description	The surrogate key of the load information entry describing the details regarding the loading of the row.
Data Type	Standards - Data Domains.ddm/Data Domains/Surrogate Key Large [LONG]
Is Part Of PrimaryKey	false
Is Required	true
Is Derived	false
Is Surrogate Key	false

Effective From Dt

Description	Establishes a period where a set of attributes are true according to the business.
Data Type	Standards - Data Domains.ddm/Data Domains/Date [DATE]
Is Part Of PrimaryKey	false
Is Required	true
Is Derived	false
Is Surrogate Key	false

Effective To Dt

Description	Ends a period of effectivity.
Data Type	Standards - Data Domains.ddm/Data Domains/Date [DATE]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Nullification Ind

Description	Specifies whether the report cancels a previously sent adverse event.
Data Type	Standards - Data Domains.ddm/Data Domains/Boolean Indicator [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Nullification Reason Cd

Description	Specifies why the adverse event report is nullified.
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

Nullification Reason Code Sk

Description	Specifies why the adverse event report is nullified.
Data Type	Standards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Nullification Reason Descr

Description	Specifies why the adverse event report is nullified.
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

Physician Sign Off Ind

Description	Specifies whether the physician has reviewed and signed off on a version of a report.
Data Type	Standards - Data Domains.ddm/Data Domains/Boolean Indicator [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Point Of Care Device Dk

Description	A numeric surrogate key used to uniquely identify entities in the dimensional model.
Data Type	Standards - Data Domains.ddm/Data Domains/Surrogate Key Large [LONG]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Public Descr

Description	The textual summary of a document intended for the general population.
Data Type	Standards - Data Domains.ddm/Data Domains/Text Large [VARCHAR(1024)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Public Title Txt

Description	The title of the document intended for the general population.
Data Type	Standards - Data Domains.ddm/Data Domains/Text Large [VARCHAR(1024)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Scientific Descr

Description	The textual summary of a document that includes extended scientific or technical information.
Data Type	Standards - Data Domains.ddm/Data Domains/Text Large [VARCHAR(1024)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Source Cd

Description	The code that corresponds to the Source Code Sk.
Data Type	Standards - Data Domains.ddm/Data Domains/Tenant Common Code [VARCHAR(80)]
Is Part Of PrimaryKey	false
Is Required	true
Is Derived	false
Is Surrogate Key	false

Source Code Descr

Description	The description that corresponds to the Source Type Cd.
Data Type	Standards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)]
Is Part Of PrimaryKey	false
Is Required	true
Is Derived	false
Is Surrogate Key	false

Source Code Sk

Description	The origin of the data identifying the actual load source, vendor, manual key entry, or context of the data in a specific row in the database.
Data Type	Standards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKey	false
Is Required	true
Is Derived	false
Is Surrogate Key	false

Storage Sts Cd

Description	Identifies the storage status of the document. For example: Active Active and archived Archived (not active) Purged
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

Storage Sts Code Sk

Description	Identifies the storage status of the document. For example: Active Active and archived Archived (not active) Purged
Data Type	Standards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Storage Sts Descr

Description	Identifies the storage status of the document. For example: Active Active and archived Archived (not active) Purged
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

Sub Type Cd

Description	Specifies a further classification of report type. For example: An Adverse Event Report would map to Document Type Code and the Safety Report Sub Type Code would map to a 7-day AE Report.
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

Sub Type Code Sk

Description	Specifies a further classification of report type. For example: An Adverse Event Report would map to Document Type Code and the Safety Report Sub Type Code would map to a 7-day AE Report.
Data Type	Standards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Sub Type Descr

Description	Specifies a further classification of report type. For example: An Adverse Event Report would map to Document Type Code and the Safety Report Sub Type Code would map to a 7-day AE Report.
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

Tenant Sk

Description	The surrogate key of the entry identifying the legal owner of the data.
Data Type	Standards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKey	false
Is Required	true
Is Derived	false
Is Surrogate Key	false

Unique Document File Nm

Description	Indicates a reference to a website, ftp, file path or other location from which the document contents can be retrieved.
Data Type	Standards - Data Domains.ddm/Data Domains/Name Long [VARCHAR(255)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Unique Document Num

Description	Indicates the unique document identification number assigned by the sending system.
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

Valid From Ts

Description	Establishes a period where a set of attributes are true in the source system. This would be populated with the transaction timestamp and would be used for the snapshot date.
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

Valid To Ts

Description	Ends a period of validity.
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

Relationship Details

Document Dimension_Point Of Care Device Dimension_FK

Is Identifying Relationship	false
Child Table	Document Dimension
Child Multiplicity	ZERO_TO_MANY
Child Referential Integrity: On Delete	NONE
Child Referential Integrity: On Insert	NONE
Child Referential Integrity: On Update	NONE
Parent Table	Point Of Care Device Dimension
Parent Multiplicity	ZERO_TO_ONE
Parent Referential Integrity: On Delete	NONE
Parent Referential Integrity: On Insert	NONE
Parent Referential Integrity: On Update	NONE

Primary Key Details

Document Dimension PK

Key Attribute

Document Dk

Overview

Top

Package

Entity

Dimensional Warehouse Model Data Model