| Business Data Model Data Model |
| Description | The quantity, frequency, priority and timings that are associated with clinical 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 | |
 Clinical Order Item Timing Quantity_Clinical Order Item_FK |
|
| Clinical Order Item Timing Quantity_Requisition Order_FK |
|
| Clinical Order Item Timing Quantity_Dietary Order_FK |
|
| Dependencies | |
 NONE |
|
| Reverse Dependencies | |
| |
|
| Attribute Details |
Service Condition Txt
| Description | A descriptive text that explains the circumstances under which the service must be delivered, and explains that human review is needed to determine how and when this service must be given. For example: If Hb is below 8.0gm/dl, transfuse patient |
| 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. |
| 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 | The units of measure in which the Service Duration Qty is expressed. For example: Days Weeks Hours |
| 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 | The specific times when the service is to be delivered. |
| 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 | The descriptive, free-text notes about the service instruction that can include a detailed description of the conditions or procedure for administering the service. |
| 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. For example: Blood Transfusion over 4 hours IV Antibiotics over 30 minutes |
| 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 | The units of measure in which service occurrence duration quantity is expressed. For example: Minutes Hours |
| 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 clinical service that must be provided at each service interval. For example: If two blood cultures are obtained every four hours, the quantity is 2. |
| 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 | The unit of measure for the numeric quantity of the service that should be provided at each service interval. For example: Bottles |
| 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 | Used to define the scheduled time interval between services. For example: Every 4 hours Every 6 hours |
| 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. For example: QID - Four Times Daily OD- Once Daily |
| 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 | The very first date and time the service should start. |
| 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 very last date and time the service should be performed. |
| 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 should result from this service request. |
| 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 | true |
| Is Derived | false |
| Is Surrogate Key | false |
| Relationship Details |
Clinical Order Item Timing Quantity_Clinical Order Item_FK
| Is Identifying Relationship | true |
| Child Table | Clinical Order Item 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 | Clinical Order Item |
| Parent Multiplicity | ONE |
| Parent Referential Integrity: On Delete | NONE |
| Parent Referential Integrity: On Insert | NONE |
| Parent Referential Integrity: On Update | NONE |
Clinical Order Item Timing Quantity_Requisition Order_FK
| Is Identifying Relationship | true |
| Child Table | Clinical Order Item 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 | Requisition Order |
| Parent Multiplicity | ONE |
| Parent Referential Integrity: On Delete | NONE |
| Parent Referential Integrity: On Insert | NONE |
| Parent Referential Integrity: On Update | NONE |
Clinical Order Item Timing Quantity_Dietary Order_FK
| Is Identifying Relationship | true |
| Child Table | Clinical Order Item 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 | Dietary Order |
| 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 |