Cyclic Group Maximum Repeat CntCyclic IndSequence Condition Time Interval QtySequence Condition Time Interval Unit Of MeasureSequence Condition TypeSequence Results IndSpecial Service Request Relationship IdTiming Quantity Relationship Seq
| Business Data Model Data Model |
| Description | A relationship between the service requests and their quantity timings. |
| Relationship | |
 Quantity Timing Relationship _Quantity Timing_FK |
|
| Dependencies | |
 NONE |
|
| Reverse Dependencies | |
| |
|
| Attribute Details |
Cyclic Group Maximum Repeat Cnt
| Description | The total number of repeats is constrained by the end date and time of the last repeat or the end date/time of the parent, whichever is first. For example: If the total number or repeats is valued at 10 and the group has already repeated 5 times, the current order will not be repeated again if either the current order, or the prior order in the cycle, has reached its end date/time. |
| 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 |
Cyclic Ind
| Description | Indicates whether this service request is the first or last service request in a cyclic series of service requests. If not present, indicates that the current service request is neither the first or last service request in a cyclic series of service requests. |
| 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 |
Sequence Condition Time Interval Qty
| Description | Indicates the units of the interval of time between the start/end of the related service request(s) and the start/end of the current service request. |
| 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 |
Sequence Condition Time Interval Unit Of Measure
| Description | The interval of time between the start/end of the related service request(s) and the start/end of the current service request. |
| 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 |
Sequence Condition Type
| Description | Defines the relationship between the start/end of the related service request(s) and the current service request. Values: EE End related service request(s), end current service request. ES End related service request(s), start current service request. SS Start related service request(s), start current service request. SE Start related service request(s), end current service request. |
| 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 |
Sequence Results Ind
| Description | Indicates the sequence/results flag value related to a timing/quantity of an order. For example: S - sequence condition C - cyclical (repeating cycle of orders) |
| 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 |
Special Service Request Relationship Id
| Description | Defines an additional or alternate relationship between this service request and other service requests. Its primary intended use is for Pharmacy administration service requests, but it may be useful for other domains. For example: N Nurse prerogative C Compound T Tapering E Exclusive S Simultaneous |
| 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 |
Timing Quantity Relationship Seq
| Description | For the first timing specification transmitted, the sequence number shall be 1; for the second timing specification, it shall be 2; and so on. |
| 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 |
Quantity Timing Relationship _Quantity Timing_FK
| Description | This relationship is used to form a relationship between the service request the TQ1 [Quantity Timing] /TQ2 [Quantity Timing Relationship] segments are associated with, and other service requests. This segment will link the current service request with one or more other service requests. |
| Is Identifying Relationship | false |
| Child Table | Timing Quantity Relationship |
| Child Role Name | defines |
| 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 | Timing Quantity |
| Parent Multiplicity | ZERO_TO_ONE |
| Parent Referential Integrity: On Delete | NONE |
| Parent Referential Integrity: On Insert | NONE |
| Parent Referential Integrity: On Update | NONE |
| Business Data Model Data Model |