Business Data Model Data Model

Entity

Entity Order

Description

A service request for a patient. Orders reflect clinical directives, medications to be prescribed, lab testing, radiology exams, and other activities to effectively treat the patient.

Attributes
Accession Num
Advanced Beneficiary Notice
Advanced Beneficiary Notice Override Reason
Call Back Phone Num
Diagnostic Service Section
Enterer Authorization Mode
Enterer Organization
Entering Device Name
Filler Order Num
Fillers Expected Availability Ts
Order Action Reason
Order Action Status
Order Discontinue Ts
Order Mode
Order Signed Ind
Order Status
Order Status Modifier
Order Status Ts
Order Transaction Ts
Order Type
Parent Order Num
Placer Group Num
Placer Order Num
Response Code
Result Handling Code
Sensitivity Level

Relationship
Order_Practitioner_FK1
Order Enterer Location
Order_Practitioner_FK3
Order_Provider_FK
Order_Order_FK
Order_Encounter_FK
Order_Practitioner_FK
Order_Practitioner_FK2
Order_Encounter_FK1
Order_Encounter_FK2
Order_Order Set_FK
Order_Encounter_FK3
Order_Document_FK
Order_Location_FK
Order_Location_FK1
Order_Activity_FK

Dependencies
NONE

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	true
Is Derived	false
Is Surrogate Key	false

Advanced Beneficiary Notice

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

Advanced Beneficiary Notice Override Reason

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

Diagnostic Service Section

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

Enterer Authorization Mode

Description	The form of authorization a recorder had from the responsible practitioner to create or change an order. For example: Electronic Email Fax In Person Mail Paper Phone Reflexive (Automated system) Video conference Voice
Data Type	Standards - Data Domains.ddm/Data Domains/Enumeration [VARCHAR(20)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Enterer Organization

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

Entering Device Name

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

Order Action Reason

Description	Indicates the reason for the order action event. For example: Patient refused Patient discharged
Data Type	Standards - Data Domains.ddm/Data Domains/Enumeration [VARCHAR(20)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Order Action Status

Description	Indicates the action associated with an order. For example: Cancel On Hold Pending
Data Type	Standards - Data Domains.ddm/Data Domains/Enumeration [VARCHAR(20)]
Is Part Of PrimaryKey	false
Is Required	true
Is Derived	false
Is Surrogate Key	false

Order 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

Description	The mode of the order. For example: Normal order (Default) Future order Standing order
Data Type	Standards - Data Domains.ddm/Data Domains/Enumeration [VARCHAR(20)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

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 Status

Description	The status of an order. For example: Some, but not all, results available Order was canceled 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/Enumeration [VARCHAR(20)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Order Status Modifier

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

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

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

Response Code

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

Result Handling Code

Description	Indicates how and under what conditions the outcome of a test or observation is to be treated. For example: Give to patient Notify provider when ready
Data Type	Standards - Data Domains.ddm/Data Domains/Enumeration [VARCHAR(20)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Sensitivity Level

Description	The level of security, sensitivity, or both, 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/Enumeration [VARCHAR(20)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Relationship Details

Order_Practitioner_FK1

Description	This relationship identifies the person who verified the accuracy of the entered request.
Is Identifying Relationship	false
Child Table	Order
Child Role Name	verifier
Child Multiplicity	ONE_TO_MANY
Child Referential Integrity: On Delete	NONE
Child Referential Integrity: On Insert	NONE
Child Referential Integrity: On Update	NONE
Parent Table	Practitioner
Parent Multiplicity	ZERO_TO_ONE
Parent Referential Integrity: On Delete	NONE
Parent Referential Integrity: On Insert	NONE
Parent Referential Integrity: On Update	NONE

Order Enterer Location

Description	This field specifies the location (for example, nurse station, ancillary service location, clinic, floor) where the person who entered the request was physically located when the order was entered.
Is Identifying Relationship	false
Child Table	Order
Child Role Name	was entered at
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	Location
Parent Multiplicity	ZERO_TO_ONE
Parent Referential Integrity: On Delete	NONE
Parent Referential Integrity: On Insert	NONE
Parent Referential Integrity: On Update	NONE

Order_Practitioner_FK3

Description	This relationship identifies the person who is responsible for creating the request (i.e., ordering physician).
Is Identifying Relationship	false
Child Table	Order
Child Role Name	placer
Child Multiplicity	ZERO_TO_MANY
Child Referential Integrity: On Delete	NONE
Child Referential Integrity: On Insert	NONE
Child Referential Integrity: On Update	NONE
Parent Table	Practitioner
Parent Multiplicity	ZERO_TO_ONE
Parent Referential Integrity: On Delete	NONE
Parent Referential Integrity: On Insert	NONE
Parent Referential Integrity: On Update	NONE

Order_Provider_FK

Description	It defines the details of the Facility.
Is Identifying Relationship	false
Child Table	Order
Child Role Name	facility details
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	Provider
Parent Multiplicity	ONE
Parent Referential Integrity: On Delete	NONE
Parent Referential Integrity: On Insert	NONE
Parent Referential Integrity: On Update	NONE

Order_Order_FK

Is Identifying Relationship	false
Child Table	Order
Child Role Name	is child of
Child Multiplicity	ZERO_TO_MANY
Child Referential Integrity: On Delete	NONE
Child Referential Integrity: On Insert	NONE
Child Referential Integrity: On Update	NONE
Parent Table	Order
Parent Multiplicity	ZERO_TO_ONE
Parent Referential Integrity: On Delete	NONE
Parent Referential Integrity: On Insert	NONE
Parent Referential Integrity: On Update	NONE

Order_Encounter_FK

Is Identifying Relationship	false
Child Table	Order
Child Role Name	relates to
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	Encounter
Parent Multiplicity	ZERO_TO_ONE
Parent Referential Integrity: On Delete	NONE
Parent Referential Integrity: On Insert	NONE
Parent Referential Integrity: On Update	NONE

Order_Practitioner_FK

Description	This relationships identifies the person who initiated the event represented by the corresponding order control code. For example, if the order control code is CA (cancel order request), this field represents the person who requested the order cancellation. This person is typically a care provider but may not always be the same as ordering provider (placer).
Is Identifying Relationship	false
Child Table	Order
Child Role Name	action by
Child Multiplicity	ZERO_TO_MANY
Child Referential Integrity: On Delete	NONE
Child Referential Integrity: On Insert	NONE
Child Referential Integrity: On Update	NONE
Parent Table	Practitioner
Parent Multiplicity	ZERO_TO_ONE
Parent Referential Integrity: On Delete	NONE
Parent Referential Integrity: On Insert	NONE
Parent Referential Integrity: On Update	NONE

Order_Practitioner_FK2

Description	This relationship identifies the person who actually keyed the request into the application.
Is Identifying Relationship	false
Child Table	Order
Child Role Name	enterer
Child Multiplicity	ZERO_TO_MANY
Child Referential Integrity: On Delete	NONE
Child Referential Integrity: On Insert	NONE
Child Referential Integrity: On Update	NONE
Parent Table	Practitioner
Parent Multiplicity	ONE
Parent Referential Integrity: On Delete	NONE
Parent Referential Integrity: On Insert	NONE
Parent Referential Integrity: On Update	NONE

Order_Encounter_FK1

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

Order_Encounter_FK2

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

Order_Order Set_FK

Description	This only applies to orders that have been placed following the use of an order set and connects the order to the order set item that led to it being placed.
Is Identifying Relationship	false
Child Table	Order
Child Role Name	generated from
Child Multiplicity	ZERO_TO_MANY
Child Referential Integrity: On Delete	NONE
Child Referential Integrity: On Insert	NONE
Child Referential Integrity: On Update	NONE
Parent Table	Order Set
Parent Multiplicity	ZERO_TO_ONE
Parent Referential Integrity: On Delete	NONE
Parent Referential Integrity: On Insert	NONE
Parent Referential Integrity: On Update	NONE

Order_Encounter_FK3

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

Order_Document_FK

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

Order_Location_FK

Is Identifying Relationship	false
Child Table	Order
Child Role Name	intended dispense to
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	Location
Parent Multiplicity	ZERO_TO_ONE
Parent Referential Integrity: On Delete	NONE
Parent Referential Integrity: On Insert	NONE
Parent Referential Integrity: On Update	NONE

Order_Location_FK1

Is Identifying Relationship	false
Child Table	Order
Child Role Name	intended dispense from
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	Location
Parent Multiplicity	ZERO_TO_ONE
Parent Referential Integrity: On Delete	NONE
Parent Referential Integrity: On Insert	NONE
Parent Referential Integrity: On Update	NONE

Order_Activity_FK

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

Overview

Top

Package

Entity

Business Data Model Data Model