Atomic Warehouse Model Data Model

Entity

Entity Pharmacy Order Timing Quantity

Description

Specifies the complex timing of events and actions for the Medication Administration such as those that occur in order management and scheduling systems. This segment determines the quantity, frequency, priority, and timing of a service. By allowing the segment to repeat, it is possible to have service requests that vary the quantity, frequency and priority of a service request over time.

Attributes
Effective From Dt
Effective To Dt
Load Info Sk
Pharmacy Order Sk
Service Calculated Qty
Service Calculated UOM Code Sk
Service Condition Txt
Service Conjunction Code Sk
Service Duration Qty
Service Duration UOM Code Sk
Service Explicit Tm
Service Instruction Txt
Service Occurrence Duration Qty
Service Occurrence Duration UOM Code Sk
Service Priority Code Sk
Service Qty
Service Quantity UOM Code Sk
Service Relative Time Qty
Service Relative Time UOM Code Sk
Service Repeat Frequency Code Sk
Service Requested Start Ts
Service Requested Stop Ts
Service Total Occurrence Cnt
Source Code Sk
Tenant Sk
Timing Quantity Seq
Valid From Ts
Valid To Ts

Relationship
Pharmacy Order Timing Quantity_Pharmacy Order_FK

Primary Key
Pharmacy Order Timing Quantity PK

Dependencies

Reverse Dependencies

Attribute Details

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

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

Pharmacy Order Sk

Description	This element is the anchor surrogate key for the Pharmacy Order 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

Service Calculated Qty

Description	Specifies the calculated numeric quantity of the medication administration service that should be provided at each interval. For Example: If two saline nebulizers are to be given every 4 hours then the quantity is 2
Data Type	Standards - Data Domains.ddm/Data Domains/Number Integer [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Service Calculated UOM Code Sk

Description	The unit of measure in which the calculated medication administration service quantity is expressed. For Example: If two saline nebulizers are to be given every 4 hours then the unit of measure is nebulizer
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

Service Condition Txt

Description	Descriptive text which describes the circumstances for when the service should be delivered. The presence of this text means that human review is needed in order to determine the how and/or when this service should be given. For Example: For acute pain For nausea and vomiting
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

Service Conjunction Code Sk

Description	Indicates how the medication administration service should be delivered in relation to any other medication administration service. For example: Synchronous Asynchronous Actuation Time
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

Service Duration Qty

Description	The duration for which the service is requested. For Example: 1 week 5 days
Data Type	Standards - Data Domains.ddm/Data Domains/Quantity Integer [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Service Duration UOM Code Sk

Description	The units of measure in which the medication administration Service Duration Qty is expressed. For Example: Days Weeks Hours
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

Service Explicit Tm

Description	The specific times when the medication administration service is to be delivered.
Data Type	Standards - Data Domains.ddm/Data Domains/Time [TIME]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Service Instruction Txt

Description	The descriptive free text notes associated with the service instruction. It may include a detailed description of the conditions or procedure to be followed when administering the medication.
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

Service Occurrence Duration Qty

Description	The duration for a single performance of a medication administration service. For Example: IV Antibiotics over 30 minutes
Data Type	Standards - Data Domains.ddm/Data Domains/Quantity Integer [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Service Occurrence Duration UOM Code Sk

Description	The units of measure in which medication administration service occurrence duration quantity is expressed. For example: Minutes Hours
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

Service Priority Code Sk

Description	Describes the urgency of the request. This can determine the medication administration service start date and time. For Example: Routine Stat Urgent
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

Service Qty

Description	Specifies the numeric quantity of the medication administration service that should be provided at each interval. For Example: If two saline nebulizers are to be given every 4 hours then the quantity is 2
Data Type	Standards - Data Domains.ddm/Data Domains/Quantity Float [FLOAT(15)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Service Quantity UOM Code Sk

Description	The unit of measure in which the medication administration service quantity is expressed. For Example: If two saline nebulizers are to be given every 4 hours then the unit of measure is nebulizer
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

Service Relative Time Qty

Description	Used to define the scheduled time interval between medication administration services. For Example: Every 4 hours Every 6 hours
Data Type	Standards - Data Domains.ddm/Data Domains/Quantity Integer [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Service Relative Time UOM Code Sk

Description	The units of measure in which the medication administration Service Relative Time Qty is expressed. For Example: Minutes Hours Days
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

Service Repeat Frequency Code Sk

Description	The repeating frequency with which the medication administration service is to be provided. For Example: QID - Four Times Daily OD- Once Daily
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

Service Requested Start Ts

Description	The very first date and time the medication administration service should start which is usually specified by the requester.
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

Service Requested Stop Ts

Description	The very last date and time the medication administration service should be performed which is usually specified by the requester.
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

Service Total Occurrence Cnt

Description	The total number of medication administration occurrences that should result from this service request.
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

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

Timing Quantity Seq

Description	An integer number starting at 1 and incrementing by one to provide uniqueness for each occurrence of medication administration. For Example: 2nd of 4 saline nebulizers
Data Type	Standards - Data Domains.ddm/Data Domains/Sequence Number [INTEGER]
Is Part Of PrimaryKey	true
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

Pharmacy Order Timing Quantity_Pharmacy Order_FK

Is Identifying Relationship	true
Child Table	Pharmacy Order Timing Quantity
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	Pharmacy Order
Parent Multiplicity	ONE
Parent Referential Integrity: On Delete	NONE
Parent Referential Integrity: On Insert	NONE
Parent Referential Integrity: On Update	NONE

Primary Key Details

Pharmacy Order Timing Quantity PK

Key Attribute	Pharmacy Order Sk
Key Attribute	Timing Quantity Seq
Key Attribute	Valid From Ts

Overview

Top

Package

Entity

Atomic Warehouse Model Data Model