Dimensional Warehouse Model Data Model

Entity

Entity Clinical Order Dimension

Description

The details describing an order for a clinical service or product.

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

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
Clinical Order Bk
Clinical Order Dk
Clinical Order Sk
Confidentiality Cd
Confidentiality Code Sk
Confidentiality Descr
Currency Cd
Currency Code Sk
Currency Descr
Current Ind
Date Needed
Diagnostic Service Section Cd
Diagnostic Service Section Code Sk
Diagnostic Service Section Descr
Dietary Order Type Cd
Dietary Order Type Code Sk
Dietary Order Type Descr
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 Cd
Enterer Organization Code Sk
Enterer Organization Descr
Entering Device Nm
Filler Order Num
Fillers Expected Availability Ts
Manufacturer Catalog
Manufacturer Identifier
Orderable Item Cd
Orderable Item Code Sk
Orderable Item Descr
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 Control Cd
Order Control Code Sk
Order Control Descr
Order Discontinue Ts
Order Mode Cd
Order Mode Code Sk
Order Mode Descr
Order Signed Ind
Order Start Ts
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
Order Transaction Ts
Order Type Cd
Order Type Code Sk
Order Type Descr
Parent Order Num
Patient Escort Required Cd
Patient Escort Required Code Sk
Patient Escort Required Descr
Patient Transport Arranged Cd
Patient Transport Arranged Code Sk
Patient Transport Arranged Descr
Patient Transport Comment Txt
Patient Transport Mode Cd
Patient Transport Mode Code Sk
Patient Transport Mode Descr
Placer Group Num
Placer Order Field One Txt
Placer Order Field Two Txt
Placer Supplemental Service Information Txt
Point Of Care Device Dk
Practice Charge Amt
Priority Seq
Response Cd
Response Code Sk
Response Descr
Result Handling Cd
Result Handling Code Sk
Result Handling Descr
Source Cd
Source Code Descr
Source Code Sk
Tenant Sk
Valid From Ts
Valid To Ts
Vendor Catalog

Relationship
Clinical Order Dimension_Point Of Care Device Dimension_FK

Primary Key
Clinical 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 to call for clarification of a request or other information regarding the order.
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

Clinical 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

Clinical 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

Clinical 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

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

Currency Cd

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

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

Currency Descr

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

Date Needed

Description	Contains the date this item is required.
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

Diagnostic Service Section Cd

Description	Indicates the section of the diagnostic service where an observation is performed. If the study is performed by an outside service, the identification of that service should also be recorded. For Example: Audiology Blood Gases Blood Bank Cardiac Ultrasound Cardiac Catheterization CAT Scan Chemistry Cytopathology Electrocardiac Electroneuro
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

Diagnostic Service Section Code Sk

Description	Indicates the section of the diagnostic service where an observation is performed. If the study is performed by an outside service, the identification of that service should also be recorded. For example: Audiology Blood Gases Blood Bank Cardiac Ultrasound Cardiac Catheterization CAT Scan Chemistry Cytopathology Electrocardiac Electroneuro
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 Section Descr

Description	Indicates the section of the diagnostic service where an observation is performed. If the study is performed by an outside service, the identification of that service should also be recorded. For Example: Audiology Blood Gases Blood Bank Cardiac Ultrasound Cardiac Catheterization CAT Scan Chemistry Cytopathology Electrocardiac Electroneuro
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

Dietary Order Type Cd

Description	Indicates the type of order. For example: Diet Supplement Preference
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

Dietary Order Type Code Sk

Description	Indicates the type of order. For example: Diet Supplement Preference
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

Dietary Order Type Descr

Description	Indicates the type of order. For example: Diet Supplement Preference
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

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 Cd

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/Tenant Common Code [VARCHAR(80)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Enterer Organization Code Sk

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/Surrogate Key [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Enterer Organization Descr

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

Entering Device Nm

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

Manufacturer Catalog

Description	The manufacturer's catalog number or code for this item.
Data Type	Standards - Data Domains.ddm/Data Domains/Identifier [VARCHAR(80)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Manufacturer Identifier

Description	Contains the unique code that identifies the manufacturer on the application receiving the requisition.
Data Type	Standards - Data Domains.ddm/Data Domains/Identifier [VARCHAR(80)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Orderable Item Cd

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

Orderable Item Code Sk

Description	An item which can be ordered 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

Orderable Item Descr

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

Description	The date and time an order was stopped or discontinued.
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 Mode Cd

Description	The mode of the order. For example: Normal order (Default) Future order Standing order
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 Mode Code Sk

Description	The mode of the order. For example: Normal order (Default) Future order Standing order
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 Mode Descr

Description	The mode of the order. For example: Normal order (Default) Future order Standing order
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 Signed Ind

Description	Indicates if this is a signed order.
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 Start Ts

Description	The date and time a clinical order was initiated.
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 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

Order Transaction Ts

Description	The date and time of the event that initiated the order.
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 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	false
Is Derived	false
Is Surrogate Key	false

Order 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

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

Patient Escort Required Cd

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/Tenant Common Code [VARCHAR(80)]
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 Escort Required Descr

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

Patient Transport Arranged Cd

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

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 Transport Arranged Descr

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

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 Cd

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/Tenant Common Code [VARCHAR(80)]
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

Patient Transport Mode Descr

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/Description [VARCHAR(250)]
Is Part Of PrimaryKey	false
Is Required	false
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 Field One Txt

Description	Textual information sent by the person/entity when placing an order and is stored with the clinical order results.
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 Field Two Txt

Description	Textual information sent by the person/entity when placing an order and is stored with the clinical order results.
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 Supplemental Service Information Txt

Description	The descriptive supplemental service information provided with the service request. This information may describe details such as whether the study is to be done on the right or left, for example, where the study is of the arm and the order master file does not distinguish right from left, or whether the study is to be done with or without contrast (when the order master file does not make such distinctions).
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

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

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

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

Response Cd

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/Tenant Common Code [VARCHAR(80)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Response Code Sk

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/Surrogate Key [INTEGER]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Response Descr

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

Result Handling Cd

Description	Indicates how the handling of the order result is to be managed. For example, an order may specify that the result (e.g., an x-ray film) should be given to the patient for return to the requestor.
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

Result Handling Code Sk

Description	Indicates how the handling of the order result is to be managed. For example, an order may specify that the result (e.g., an x-ray film) should be given to the patient for return to the requestor.
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

Result Handling Descr

Description	Indicates how the handling of the order result is to be managed. For example, an order may specify that the result (e.g., an x-ray film) should be given to the patient for return to the requestor.
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

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

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

Vendor Catalog

Description	The vendor's catalog number, name, or code for this item.
Data Type	Standards - Data Domains.ddm/Data Domains/Identifier [VARCHAR(80)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Relationship Details

Clinical Order Dimension_Point Of Care Device Dimension_FK

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

Clinical Order Dimension PK

Key Attribute

Clinical Order Dk

Overview

Top

Package

Entity

Dimensional Warehouse Model Data Model