| Business Data Model Data Model |
| Description | The information that describes an appointment's quantity, frequency, priority and timing. |
| Relationship | |
 Appointment Timing Quantity_Appointment_FK |
|
| Dependencies | |
 NONE |
|
| Reverse Dependencies | |
| |
|
| Attribute Details |
Condition Txt
| Description | Describes the conditions under which the appointment is to be carried out. |
| 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 |
Conjunction
| Description | Indicates that a second Timing Quantity segment is to follow. Values: 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 |
Duration Qty
| Description | Indicates the duration for which the service is requested. |
| 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 |
Duration Unit Of Measure
| Description | Indicates the unit of measure in which the duration is expressed. For example: Hours Days Months |
| 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 |
Explicit Tm
| Description | Explicitly lists the actual times referenced by the code in 'Service Repeat Frequency Cd'. This field will be used to clarify the 'Service Repeat Frequency Cd' 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 |
Instruction Txt
| Description | Indicates the instructions for a specific appointment. |
| 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 |
Occurrence Duration Qty
| Description | Indicates the duration for which a single performance of a service is requested. |
| 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 |
Occurrence Duration Unit Of Measure
| Description | Indicates the time unit of measure for the duration of a single performance of a requested service. |
| 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 |
Quantity Unit Of Measure
| Description | The unit of measure used to specify the numeric quantity of the service that should be provided at each service interval. |
| 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 |
Relative Time Qty
| Description | Indicates the interval between schedules for 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 |
Relative Time Unit Of Measure
| Description | Indicates the time unit of measure used to express the interval between schedules for 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 |
Repeat Frequency
| Description | Indicates the repeating frequency with which the appointment is repeated. |
| 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 |
Requested Start Ts
| Description | Indicates the earliest date/time at which the services should be started which is specified by the requester. |
| 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 |
Requested Stop Ts
| Description | Indicates the latest date/time at which the services must be stopped. The requester may not always enter this value, yet the filling service may enter it based 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 |
Request Priority
| Description | Indicates the importance of the 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 |
Timing Qty
| Description | The numeric quantity of the service that must 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/Sequence Number [INTEGER] |
| Is Part Of PrimaryKey | false |
| Is Required | true |
| Is Derived | false |
| Is Surrogate Key | false |
Total Occurrence Cnt
| Description | Indicates 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 |
| Relationship Details |
Appointment Timing Quantity_Appointment_FK
| Is Identifying Relationship | false |
| Child Table | Appointment 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 | Appointment |
| 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 |