Atomic Warehouse Model Data Model

Entity

Entity Clinical Order Item Detail

Description

An item for a clinical service or product that is available for ordering.

For example:
Medication
Vital Sign check
Full Blood Count
Physiotherapy review

Attributes
Auto Dilution Factor Code Sk
Clinical Order Item Sk
Currency Code Sk
Diagnostic Service Department Code Sk
Effective From Dt
Effective To Dt
Filler Supplemental Service Information Code Sk
Filler System Field One Txt
Filler System Field Two Txt
Filler System Order Number Txt
Load Info Sk
Orderable Item Code Sk
Order Item Scheduled Ts
Patient Escort Required Code Sk
Patient Transport Arranged Code Sk
Patient Transportation Responsibility Code Sk
Patient Transport Comment Txt
Patient Transport Mode Code Sk
Practice Charge Amt
Pre Dilution Factor Code Sk
Priority Seq
Relevant Clinical Information Txt
Requestor Supplemental Service Information Code Sk
Rerun Dilution Factor Code Sk
Source Code Sk
Tenant Sk
Valid From Ts
Valid To Ts

Relationship
Clinical Order Item Detail_Clinical Order Item_FK

Primary Key
Clinical Order Item Detail PK

Dependencies

Reverse Dependencies

Attribute Details

Auto Dilution Factor Code Sk

Description	This field is the value that is to be used as the factor for automatically diluting a particular specimen by an instrument for a particular test code.
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

Clinical Order Item Sk

Description	This element is the anchor surrogate key for the Clinical Order Item data.
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	false

Currency Code Sk

Description	The currency used as the basis for all monetary amounts
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

Diagnostic Service Department Code Sk

Description	Identifies the name of the hospital division where the clinical order was performed.
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

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

Filler Supplemental Service Information Code Sk

Description	An acronym or abbreviation used to represent augmenting information from the filling system about ordering information detail not available in other fields within the Clinical Order or Clinical Order Item.
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

Filler System Field One Txt

Description	A free form text field to store any information by the filling or producing system.
Data Type	Standards - Data Domains.ddm/Data Domains/String [VARCHAR(255)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Filler System Field Two Txt

Description	A free form text field to store any information by the filling or producing system.
Data Type	Standards - Data Domains.ddm/Data Domains/String [VARCHAR(255)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Filler System Order Number Txt

Description	An external identifier assigned by the order entry system or filling application. This is a permanent identifier. It contains 2 components. The first part is a string that identifies an individual order. The second part contains the identifier for the filling application.
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

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

Orderable Item Code Sk

Description	The item ordered or requested on a Clinical Order or described in a Clinical Finding.
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

Order Item Scheduled Ts

Description	The planned date and time the requested service is to commence.
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

Patient Escort Required Code Sk

Description	Indicates whether the patient requires a companion to help the patient to or from a service location.
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

Patient Transport Arranged Code Sk

Description	Indicates whether patient travel or conveyance has been organized.
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

Patient Transportation Responsibility Code Sk

Description	Describes what department or hospital personnel role is required to schedule and arrange for patients to be conveyed to or from a service location.
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

Patient Transport Comment Txt

Description	Descriptive information about the patient's transport which may include special measures or arrangements. For Example: Patient is on continuous oxygen, oxygen supply required Patient is positive for MRSA
Data Type	Standards - Data Domains.ddm/Data Domains/Free Text [VARCHAR(1024)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Patient Transport Mode Code Sk

Description	Describes how a patient is to be moved to or from a service location. For Example: Wheelchair Stretcher Ambulance
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

Practice Charge Amt

Description	A sum of money that represents what the ordering organization must pay to fulfill the request.
Data Type	Standards - Data Domains.ddm/Data Domains/Currency Amount [DECIMAL(14,2)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Pre Dilution Factor Code Sk

Description	This field is the value that is to be used as the factor for a particular specimen that is delivered to the automated system as pre-diluted for a particular test code.
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

Priority Seq

Description	A number that identifies the relative order of importance for the requested clinical order.
Data Type	Standards - Data Domains.ddm/Data Domains/Sequence Number [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Relevant Clinical Information Txt

Description	Additional descriptive information about the service request. This type information could include the reason for request, suspected diagnosis or patient's current condition. For Example: Rule out Sickle Cell Anaemia
Data Type	Standards - Data Domains.ddm/Data Domains/Free Text [VARCHAR(1024)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Requestor Supplemental Service Information Code Sk

Description	An acronym or abbreviation used to represent augmenting information from the filling system about ordering information detail not available in other fields within the Clinical Order or Clinical Order Item.
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

Rerun Dilution Factor Code Sk

Description	This field is the value that is to be used as the factor for automatically diluting a particular specimen in case of rerun for a particular test code.
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

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

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

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	true
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

Clinical Order Item Detail_Clinical Order Item_FK

Is Identifying Relationship	true
Child Table	Clinical Order Item Detail
Child Role Name	is detail for
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	Clinical Order Item
Parent Multiplicity	ONE
Parent Referential Integrity: On Delete	NONE
Parent Referential Integrity: On Insert	NONE
Parent Referential Integrity: On Update	NONE

Primary Key Details

Clinical Order Item Detail PK

Key Attribute	Clinical Order Item Sk
Key Attribute	Valid From Ts

Overview

Top

Package

Entity

Atomic Warehouse Model Data Model