| Business Data Model Data Model |
| Description | The quantity, frequency, priority, and timings that are associated with orders. This type of information may be specified by a practitioner when an order is being requested. For example: 2 Routine blood cultures once daily for 5 consecutive days 1 Full blood count each morning for 3 days |
| Relationship | |
 Timing Quantity_Order_FK |
|
| Planned Dispensed Timing Quantity_Pharmacy Order Medication_FK |
|
| Dependencies | |
 NONE |
|
| Reverse Dependencies | |
| |
|
| Attribute Details |
Service Condition Txt
| Description | A textual description of the conditions under which the drug is 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 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 Type
| 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/Enumeration [VARCHAR(20)] |
| 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, nonzero 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 Unit Of Measure
| Description | Indicates the unit of measure for the Service Duration Qty. |
| 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 |
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 | Textual instructions about the service requested, performed or both. |
| 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, nonzero number when populated. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Quantity Integer [INTEGER] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Service Occurrence Duration Unit Of Measure
| Description | Indicates the unit of measure for the Service Occurrence Duration Qty. |
| 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 |
Service Priority
| Description | Describes the urgency of the request. For example: Route Stat Urgent |
| 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 |
Service Qty
| Description | The numeric quantity of the service that can be provided at each service interval. For example: If two blood cultures are obtained every four hours, the quantity is 2. If three units of blood are typed and cross-matched, the quantity is 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 Unit Of Measure
| Description | Indicates the unit of measure for the Service Qty. |
| 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 |
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 Unit Of Measure
| 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/Enumeration [VARCHAR(20)] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Service Repeat Frequency
| 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/Enumeration [VARCHAR(20)] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| 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 | false |
| Is Derived | false |
| Is Surrogate Key | false |
Service Requested Stop Ts
| Description | The date and time when the service must be performed, when completed by the requester of the service. If it has not been performed by the specified time, it should not be performed at all. The requester may not always enter this value, yet the filling service may enter the value basis on 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 | false |
| Is Derived | false |
| Is Surrogate Key | false |
Service Total Occurrence Cnt
| Description | The total number of occurrences of a service that results from this service request. If the end date, end time and the total occurrences are valued, and the occurrences extend beyond the end date and end time, the end date and end time take precedence. Otherwise, the number of occurrences takes precedence. |
| 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 |
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 | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
| Relationship Details |
Timing Quantity_Order_FK
| Description | It defines the Frequency, Quantities etc for the Order. |
| Is Identifying Relationship | false |
| Child Table | Timing Quantity |
| Child Role Name | for |
| 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 |
Planned Dispensed Timing Quantity_Pharmacy Order Medication_FK
| Description | This relationship identifies the Planned Dispensed Frequency and Quantity for the planned dosage. |
| Is Identifying Relationship | false |
| Child Table | Timing Quantity |
| Child Multiplicity | ZERO_TO_MANY |
| Child Referential Integrity: On Delete | NONE |
| Child Referential Integrity: On Insert | NONE |
| Child Referential Integrity: On Update | NONE |
| Parent Table | Pharmacy Order / Medication |
| Parent Multiplicity | ONE |
| Parent Referential Integrity: On Delete | NONE |
| Parent Referential Integrity: On Insert | NONE |
| Parent Referential Integrity: On Update | NONE |
| Business Data Model Data Model |