Dimensional Warehouse Model Data Model

Entity

Entity Pharmacy Order Dimension

Description

An order that specifies the medications ordered for a patient. It includes any type of pharmacy order, including inpatient (unit dose and compound unit dose), outpatient, IVs, and hyperalimentation IVs (nutritional IVs), as well as other non-pharmacy treatments (respiratory therapy, oxygen and nursing treatments).

Attributes
Accession Num
Advanced Beneficiary Notice Cd
Advanced Beneficiary Notice Code Sk
Advanced Beneficiary Notice Descr
Advanced Beneficiary Notice Override Reason Cd
Advanced Beneficiary Notice Override Reason Code Sk
Advanced Beneficiary Notice Override Reason Descr
AWM Load Info Sk
Call Back Phone Num
Confidentiality Cd
Confidentiality Code Sk
Confidentiality Descr
Current Ind
Drug Compound Ind
DWM Load Info Sk
Effective From Dt
Effective To Dt
Enterer Authorization Mode Cd
Enterer Authorization Mode Code Sk
Enterer Authorization Mode Descr
Enterer Organization Nm
Entering Device
Filler Order Num
Fillers Expected Availability Ts
Human Review Needed Ind
Order Action Reason Cd
Order Action Reason Code Sk
Order Action Reason Descr
Order Action Status Cd
Order Action Status Code Sk
Order Action Status Descr
Order Status Cd
Order Status Code Sk
Order Status Descr
Order Status Modifier Cd
Order Status Modifier Code Sk
Order Status Modifier Descr
Order Status Ts
Parent Order Num
Pharmacy Order Bk
Pharmacy Order Dk
Pharmacy Order Sk
Placer Group Num
Placer Order Num
Point Of Care Device Dk
Response Ind
Source Cd
Source Code Descr
Source Code Sk
Substitution Status Cd
Substitution Status Code Sk
Substitution Status Descr
Tenant Sk
Type Cd
Type Code Sk
Type Descr
Valid From Ts
Valid To Ts

Relationship
Pharmacy Order Dimension_Point Of Care Device Dimension_FK

Primary Key
Pharmacy Order Dimension PK

Dependencies

Reverse Dependencies

Attribute Details

Accession Num

Description	A workflow-management generated number that identifies the filler order (diagnostic service) for an imaging order. This identifier corresponds one-to-one to the order filler number but is used in internal tracking of the work within a diagnostic imaging service department.
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

Advanced Beneficiary Notice Cd

Description	Indicates the status of the patient's or the patient's representative's consent for responsibility to pay for potentially uninsured services. This element is introduced to satisfy CMS Medical Necessity requirements for outpatient services. This element indicates (a) whether the associated diagnosis codes for the service are subject to medical necessity procedures (b) whether, for this type of service, the patient has been informed that they may be responsible for payment for the service, and (c) whether the patient agrees to be billed for this service. For example: Service is subject to medical necessity procedures Patient has been informed of responsibility, and agrees to pay for service Patient has been informed of responsibility, and asks that the payer be billed Advanced Beneficiary Notice has not been signed
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

Advanced Beneficiary Notice Code Sk

Description	Indicates the status of the patient's or the patient's representative's consent for responsibility to pay for potentially uninsured services. This element is introduced to satisfy CMS Medical Necessity requirements for outpatient services. This element indicates (a) whether the associated diagnosis codes for the service are subject to medical necessity procedures (b) whether, for this type of service, the patient has been informed that they may be responsible for payment for the service, and (c) whether the patient agrees to be billed for this service. For example: Service is subject to medical necessity procedures Patient has been informed of responsibility, and agrees to pay for service Patient has been informed of responsibility, and asks that the payer be billed Advanced Beneficiary Notice has not been signed
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

Advanced Beneficiary Notice Descr

Description	Indicates the status of the patient's or the patient's representative's consent for responsibility to pay for potentially uninsured services. This element is introduced to satisfy CMS Medical Necessity requirements for outpatient services. This element indicates (a) whether the associated diagnosis codes for the service are subject to medical necessity procedures (b) whether, for this type of service, the patient has been informed that they may be responsible for payment for the service, and (c) whether the patient agrees to be billed for this service. For example: Service is subject to medical necessity procedures Patient has been informed of responsibility, and agrees to pay for service Patient has been informed of responsibility, and asks that the payer be billed Advanced Beneficiary Notice has not been signed
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

Advanced Beneficiary Notice Override Reason Cd

Description	Indicates the reason why the patient did not sign an Advanced Beneficiary Notice. The reason may be coded or it may be a free text entry.
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

Advanced Beneficiary Notice Override Reason Code Sk

Description	Indicates the reason why the patient did not sign an Advanced Beneficiary Notice. The reason may be coded or it may be a free text entry.
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

Advanced Beneficiary Notice Override Reason Descr

Description	Indicates the reason why the patient did not sign an Advanced Beneficiary Notice. The reason may be coded or it may be a free text entry.
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

Call Back Phone Num

Description	The telephone number for reporting a status or a result using the standard format with extension and/or beeper number when applicable.
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

Confidentiality Cd

Description	The level of security and/or sensitivity surrounding the order. For example: Very restricted Restricted Usual control Employee Unwed mother Very important person or celebrity Psychiatric patient AIDS patient HIV(+) patient Alcohol/drug treatment patient
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 Code Sk

Description	The level of security and/or sensitivity surrounding the order. For example: Very restricted Restricted Usual control Employee Unwed mother Very important person or celebrity Psychiatric patient AIDS patient HIV(+) patient Alcohol/drug treatment patient
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 Descr

Description	The level of security and/or sensitivity surrounding the order. For example: Very restricted Restricted Usual control Employee Unwed mother Very important person or celebrity Psychiatric patient AIDS patient HIV(+) patient Alcohol/drug treatment patient
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

Drug Compound Ind

Description	Indicates the type of component. For Example: Additive Base
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

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

Enterer Authorization Mode Cd

Description	Indicates the form of authorization a recorder had from the responsible practitioner to create or change an order. For example: Electronic E-mail Fax In Person Mail Paper Phone Reflexive (Automated system) Video-conference Voice
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

Enterer Authorization Mode Code Sk

Description	Indicates the form of authorization a recorder had from the responsible practitioner to create or change an order. For example: Electronic E-mail Fax In Person Mail Paper Phone Reflexive (Automated system) Video-conference Voice
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

Enterer Authorization Mode Descr

Description	Indicates the form of authorization a recorder had from the responsible practitioner to create or change an order. For example: Electronic E-mail Fax In Person Mail Paper Phone Reflexive (Automated system) Video-conference Voice
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

Enterer Organization Nm

Description	Indicates the organization that the enterer belonged to at the time he/she enters/maintains the order, such as medical group or department.
Data Type	Standards - Data Domains.ddm/Data Domains/Name [VARCHAR(30)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Entering Device

Description	Identifies the physical device (terminal, PC) used to enter the order.
Data Type	Standards - Data Domains.ddm/Data Domains/Name [VARCHAR(30)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Filler Order Num

Description	The identifying number associated with 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

Fillers Expected Availability Ts

Description	The date and time the filler expects the services to be available. For Example, When a prescription is ready for pickup or when a supply will be sent or picked up, or for when a laboratory result is expected to be available.
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

Human Review Needed Ind

Description	Indicates whether or not the pharmacist or non-pharmacist treatment supplier filling the order needs to pay special attention to the text in the provider's pharmacy/treatment instructions. It indicates whether a warning is present.
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

Order Action Reason Cd

Description	Indicates the reason for the order action event. For example: Patient refused Patient discharged
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

Order Action Reason Code Sk

Description	Indicates the reason for the order action event. For example: Patient refused Patient discharged
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

Order Action Reason Descr

Description	Indicates the reason for the order action event. For example: Patient refused Patient discharged
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

Order Action Status Cd

Description	Indicates the action associated with an order. For example: Cancel On Hold Pending
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

Order Action Status Code Sk

Description	Indicates the action associated with an order. For example: Cancel On Hold Pending
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

Order Action Status Descr

Description	Indicates the action associated with an order. For example: Cancel On Hold Pending
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

Order Status Cd

Description	Indicates the current status of an order. For Example: Some, but not all, results available Order was cancelled Order is completed Order was discontinued Error, order not found Order is on hold In process, unspecified Order has been replaced In process, scheduled
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

Order Status Code Sk

Description	Indicates the current status of an order. For Example: Some, but not all, results available Order was cancelled Order is completed Order was discontinued Error, order not found Order is on hold In process, unspecified Order has been replaced In process, scheduled
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

Order Status Descr

Description	Indicates the current status of an order. For Example: Some, but not all, results available Order was cancelled Order is completed Order was discontinued Error, order not found Order is on hold In process, unspecified Order has been replaced In process, scheduled
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

Order Status Modifier Cd

Description	Indicates the modifier who refined the order status. May be used to provide additional levels of specificity or additional information for the defined order status codes.
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

Order Status Modifier Code Sk

Description	Indicates the modifier who refined the order status. May be used to provide additional levels of specificity or additional information for the defined order status codes.
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

Order Status Modifier Descr

Description	Indicates the modifier who refined the order status. May be used to provide additional levels of specificity or additional information for the defined order status codes.
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

Order Status Ts

Description	A date and time that specifies the start of the Order Status. For example: A pharmacy order becomes 'on hold' and the accompanying status timestamp is YYYY/DD/MM 00:00
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

Parent Order Num

Description	A number which uniquely represents an order in the operational system. The identifier code for the parent order which caused this observation/test/battery to be performed.
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

Pharmacy Order 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

Pharmacy Order 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

Pharmacy 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

Placer Group Num

Description	A number used to identify a group of orders.
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

Placer Order Num

Description	The placer application's order number for the service/material being ordered.
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

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

Response Ind

Description	Indicates the amount of information to be returned from the filler. Sometimes the requested level of response may not be possible immediately, but when it is possible, the filler (receiving) application must send the information.
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

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

Substitution Status Cd

Description	Indicates whether substitutions are allowed for the medication/treatment. For Example: Substitutions are not authorized Allow generic substitutions Allow therapeutic substitutions
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

Substitution Status Code Sk

Description	Indicates whether substitutions are allowed for the medication/treatment. For Example: Substitutions are not authorized Allow generic substitutions Allow therapeutic substitutions
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

Substitution Status Descr

Description	Indicates whether substitutions are allowed for the medication/treatment. For Example: Substitutions are not authorized Allow generic substitutions Allow therapeutic substitutions
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

Type Cd

Description	Indicates whether the order is to be executed in an inpatient setting or an outpatient setting.
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

Type Code Sk

Description	Indicates whether the order is to be executed in an inpatient setting or an outpatient setting.
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

Type Descr

Description	Indicates whether the order is to be executed in an inpatient setting or an outpatient setting.
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

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

Pharmacy Order Dimension_Point Of Care Device Dimension_FK

Is Identifying Relationship	false
Child Table	Pharmacy Order 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

Pharmacy Order Dimension PK

Key Attribute

Pharmacy Order Dk

Overview

Top

Package

Entity

Dimensional Warehouse Model Data Model