Business Data Model Data Model

Entity

Entity Clinical Order Item

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
Currency
Diagnostic Service Department
Filler Supplemental Service Information
Filler System Field One Txt
Filler System Field Two Txt
Filler System Order Num
Orderable Item
Order Item Requested Ts
Order Item Scheduled Ts
Patient Escort Required
Patient Transport Arranged
Patient Transportation Responsibility
Patient Transport Comment Txt
Patient Transport Mode
Practice Charge Amt
Pre Dilution Factor
Priority Seq
Relevant Clinical Information Txt
Requestor Supplemental Service Information
Rerun Dilution Factor

Relationship
Clinical Order Item_Laboratory Order_FK
Clinical Order Item_Clinical Order _FK
Clinical Order Item_Orderable Item_FK
Clinical Order Detail_Practitioner_FK

Dependencies
NONE

Reverse Dependencies

Attribute Details

Auto Dilution Factor

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/Enumeration [VARCHAR(20)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Currency

Description	The currency that is used as the basis for all monetary amounts.
Data Type	Standards - Data Domains.ddm/Data Domains/Enumeration [VARCHAR(20)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Diagnostic Service Department

Description	Identifies the name of the hospital division where the clinical order was performed.
Data Type	Standards - Data Domains.ddm/Data Domains/Enumeration [VARCHAR(20)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Filler Supplemental Service Information

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/Enumeration [VARCHAR(20)]
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 information by the filling or producing system.
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

Filler System Field Two Txt

Description	A free-form text field to store information by the filling or producing system.
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

Filler System Order Num

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

Orderable Item

Description	An item which can be ordered or described in a clinical finding.
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

Order Item Requested Ts

Description	The date and time the requested service was entered into the order entry system or filling application.
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

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

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/Enumeration [VARCHAR(20)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Patient Transport Arranged

Description	Indicates whether patient travel or conveyance has been organized.
Data Type	Standards - Data Domains.ddm/Data Domains/Enumeration [VARCHAR(20)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Patient Transportation Responsibility

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/Enumeration [VARCHAR(20)]
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

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/Enumeration [VARCHAR(20)]
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

Description	The value that must be used as the factor for a specimen that is delivered to the automated system as prediluted for a particular test code.
Data Type	Standards - Data Domains.ddm/Data Domains/Enumeration [VARCHAR(20)]
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 patient, specimen, or requested service. This type information can play a role in reporting clinical findings. For example: Rule out Sickle Cell Anaemia History of falls
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

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/Enumeration [VARCHAR(20)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Rerun Dilution Factor

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/Enumeration [VARCHAR(20)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Relationship Details

Clinical Order Item_Laboratory Order_FK

Is Identifying Relationship	false
Child Table	Clinical Order Item
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	Laboratory Order
Parent Multiplicity	ONE
Parent Referential Integrity: On Delete	NONE
Parent Referential Integrity: On Insert	NONE
Parent Referential Integrity: On Update	NONE

Clinical Order Item_Clinical Order _FK

Is Identifying Relationship	false
Child Table	Clinical Order Item
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
Parent Multiplicity	ONE
Parent Referential Integrity: On Delete	NONE
Parent Referential Integrity: On Insert	NONE
Parent Referential Integrity: On Update	NONE

Clinical Order Item_Orderable Item_FK

Is Identifying Relationship	false
Child Table	Clinical Order Item
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	Order Master
Parent Multiplicity	ONE
Parent Referential Integrity: On Delete	NONE
Parent Referential Integrity: On Insert	NONE
Parent Referential Integrity: On Update	NONE

Clinical Order Detail_Practitioner_FK

Is Identifying Relationship	false
Child Table	Clinical Order Item
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	Practitioner
Parent Multiplicity	ZERO_TO_MANY
Parent Referential Integrity: On Delete	NONE
Parent Referential Integrity: On Insert	NONE
Parent Referential Integrity: On Update	NONE

Overview

Top

Package

Entity

Business Data Model Data Model