Dimensional Warehouse Model Data Model

Entity

Entity Blood Product Order Timing Quantity Array

Description

The complex timing of events and actions for the ordered blood product transfusion. This includes the quantity, frequency, priority, and timing of a blood transfusion service.

Attributes
AWM Load Info Sk
Blood Product Order Fact Dk
Blood Product Order Sk
Current Ind
DWM Load Info Sk
Effective From Dt
Effective To Dt
Service Condition Txt
Service Conjunction Cd
Service Conjunction Code Sk
Service Conjunction Descr
Service Duration Qty
Service Duration UOM Cd
Service Duration UOM Code Sk
Service Duration UOM Descr
Service Explicit Tm
Service Instruction Txt
Service Occurrence Duration Qty
Service Occurrence Duration UOM Cd
Service Occurrence Duration UOM Code Sk
Service Occurrence Duration UOM Descr
Service Priority Cd
Service Priority Code Sk
Service Priority Descr
Service Qty
Service Quantity UOM Cd
Service Quantity UOM Code Sk
Service Quantity UOM Descr
Service Relative Time Qty
Service Relative Time UOM Cd
Service Relative Time UOM Code Sk
Service Relative Time UOM Descr
Service Repeat Frequency Cd
Service Repeat Frequency Code Sk
Service Repeat Frequency Descr
Service Requested Start Calendar Dk
Service Requested Start Ts
Service Requested Stop Calendar Dk
Service Requested Stop Ts
Service Total Occurrence Cnt
Source Code Sk
Tenant Sk
Timing Quantity Seq
Valid From Ts
Valid To Ts

Relationship
Blood Product Order Timing Quantity Array_Calendar Dimension_FK
Blood Product Order Timing Quantity Array_Calendar Dimension_FK1
Blood Product Order Timing Quantity Array_Blood Product Order Fact_FK

Primary Key
Blood Product Order Timing Quantity Array PK

Dependencies

Reverse Dependencies

Attribute Details

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

Blood Product Order Fact 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	false

Blood Product Order 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

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

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

Service Condition Txt

Description	A textual description of the conditions under which the drug is to be given. For example: PRN pain To keep blood pressure below 110. The presence of text in this field should be taken to mean that human review is needed to determine how and/or when this drug should be given.
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 Cd

Description	Identifies the second Timing Quantity segment which is to follow. For example: Synchronous Asynchronous Actuation Time
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

Service Conjunction Code Sk

Description	Identifies the second Timing Quantity segment which is to follow. 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 Conjunction Descr

Description	Identifies the second Timing Quantity segment which is to follow. For example: Synchronous Asynchronous Actuation Time
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

Service Duration Qty

Description	The duration for which the service is requested. The quantity component of this field must be a positive, non-zero number.
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 Cd

Description	Indicates the unit of measure for the Service Duration Qty.
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

Service Duration UOM Code Sk

Description	Indicates the unit of measure for the Service Duration Qty.
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 UOM Descr

Description	Indicates the unit of measure for the Service Duration Qty.
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

Service Explicit Tm

Description	Explicitly lists the actual times referenced by the Service Repeat Frequency Code. This field will be used to clarify the Service Repeat Frequency Code in cases where the actual administration times vary within an institution. If the time of the service request spans more than a single day, this field is only practical if the same times of administration occur for each day of the service request.
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	Contains textual instructions related to the service requested and/or performed.
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 which a single performance of a service is requested. The quantity component must be a positive, non-zero number when populated.
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 Occurrence Duration UOM Cd

Description	Indicates the unit of measure for the Service Duration Qty.
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

Service Occurrence Duration UOM Code Sk

Description	Indicates the unit of measure for the Service Duration Qty.
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 Occurrence Duration UOM Descr

Description	Indicates the unit of measure for the Service Occurrence Duration Qty.
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

Service Priority Cd

Description	Describes the urgency of the request. For example: Route Stat Urgent
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

Service Priority Code Sk

Description	Describes the urgency of the request. For example: Route 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 Priority Descr

Description	Describes the urgency of the request. For example: Route Stat Urgent
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

Service Qty

Description	Specifies the numeric quantity of the service that should be provided at each service interval. For example: If two blood cultures are to be obtained every 4 hours, the quantity would be 2. If three units of blood are to be typed and cross-matched, the quantity would be 3.
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 Quantity UOM Cd

Description	Indicates the unit of measure for the Service Qty.
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

Service Quantity UOM Code Sk

Description	Indicates the unit of measure for the Service Qty.
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 Quantity UOM Descr

Description	Indicates the unit of measure for the Service Qty.
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

Service Relative Time Qty

Description	Defines the interval between schedules for service request or bottle records. If this field contains a value, it overrides any value in the explicit time interval field.
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 Cd

Description	The units of measure in which the service relative time is expressed. For example: Minutes Hours Days
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

Service Relative Time UOM Code Sk

Description	The units of measure in which the service relative time 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 Relative Time UOM Descr

Description	The units of measure in which the service relative time is expressed. For example: Minutes Hours Days
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

Service Repeat Frequency Cd

Description	The repeating frequency with which the treatment is to be administered. It is similar to the frequency and SIG code tables used in order entry systems.
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

Service Repeat Frequency Code Sk

Description	The repeating frequency with which the treatment is to be administered. It is similar to the frequency and SIG code tables used in order entry systems.
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 Descr

Description	The repeating frequency with which the treatment is to be administered. It is similar to the frequency and SIG code tables used in order entry systems.
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

Service Requested Start Calendar 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	true
Is Derived	false
Is Surrogate Key	false

Service Requested Start Ts

Description	Specified by the requester, in which case it indicates the earliest date and time that the services should be started. In many cases, however, the start date/time will be implied or will be defined by other fields in the service request record (for example, urgency - STAT).
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

Service Requested Stop Calendar 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	true
Is Derived	false
Is Surrogate Key	false

Service Requested Stop Ts

Description	When filled in by the requester of the service, contains the latest date and time that the service should be performed. If it has not been performed by the specified time, it should not be performed at all. The requester may not always fill in this value, yet the filling service may fill it in on the basis of the instruction it receives and the actual start time.
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

Service Total Occurrence Cnt

Description	Indicates the total number of occurrences of a service that should result from this service request. If both the end date/time and the total occurrences are valued and the occurrences would extend beyond the end date/time, then the end date/time takes precedence. Otherwise the number of occurrences takes precedence.
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 a service delivery. For example: 3rd of 4 saline nebulizers 2nd of 4 physiotherapy assessments.
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

Blood Product Order Timing Quantity Array_Calendar Dimension_FK

Is Identifying Relationship	false
Child Table	Blood Product Order Timing Quantity Array
Child Role Name	has requested start
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	Calendar Dimension
Parent Multiplicity	ZERO_TO_ONE
Parent Referential Integrity: On Delete	NONE
Parent Referential Integrity: On Insert	NONE
Parent Referential Integrity: On Update	NONE

Blood Product Order Timing Quantity Array_Calendar Dimension_FK1

Is Identifying Relationship	false
Child Table	Blood Product Order Timing Quantity Array
Child Role Name	has requested stop
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	Calendar Dimension
Parent Multiplicity	ZERO_TO_ONE
Parent Referential Integrity: On Delete	NONE
Parent Referential Integrity: On Insert	NONE
Parent Referential Integrity: On Update	NONE

Blood Product Order Timing Quantity Array_Blood Product Order Fact_FK

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

Primary Key Details

Blood Product Order Timing Quantity Array PK

Key Attribute	Blood Product Order Fact Dk
Key Attribute	Timing Quantity Seq
Key Attribute	Valid From Ts

Overview

Top

Package

Entity

Dimensional Warehouse Model Data Model