| Business Data Model Data Model |
Description | A member of personnel that can be scheduled for an appointment. For example: Respiratory Technician Physicians Nurses |
Dependencies | |
![]() |
Reverse Dependencies | |
![]() |
Attribute Details |
Description | An indicator that shows whether the identified personnel can be substituted with equivalent personnel. For example: No - Substitution of this staff member is not allowed. Confirm - Contact the placer contact person before replacing personnel. Notify - Notify the placer contact person through normal institutional procedures that a substitution of personnel has been made. Yes - Substitution of personnel is allowed. |
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 |
Description | The duration for which a staff member is requested or scheduled for an appointment, if different from the overall duration of the requested or scheduled appointment. For example: An unvalued duration indicates that personnel is required from its start date and start time offset (specified in the previous two fields) until the end of the appointment. If no start date and start time offset is specified, the personnel is required for the full duration of the appointment. This field must be a positive, nonzero number. A negative number or zero (0) is nonsensical in the context of a duration. |
Data Type | Standards - Data Domains.ddm/Data Domains/Count [INTEGER] |
Is Part Of PrimaryKey | false |
Is Required | false |
Is Derived | false |
Is Surrogate Key | false |
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 |
Description | The requested or scheduled status of the appointment or associated location, equipment, personnel or other resource, from the point of view of the filler application. For example: Pending - Appointment has not yet been confirmed. Waitlist - Appointment has been placed on a waiting list for a particular slot or set of slots. Booked - The indicated appointment is booked. Started - The indicated appointment has begun and is in progress. Complete - The indicated appointment has completed normally (was not discontinued, canceled or deleted). Canceled - The indicated appointment was stopped from occurring (canceled before it started). Dc - The indicated appointment was discontinued (discontinued while in progress, discontinued parent appointment or discontinued child appointment). Deleted -The indicated appointment was deleted from the filler application. Blocked -The indicated time slot is/slots are blocked. Overbook - The appointment has been confirmed, but confirmed in an overbooked state. No show - The patient did not show up for the appointment. |
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 |
Description | Identifies the type of the personnel requested/scheduled for an appointment. For example: Physician Nurse Therapist |
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 |
Description | Identifies the requested resource as a member of the indicated group. |
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 |
Description | The offset that the personnel resource needs for the appointment, and is expressed in units of time relative to the scheduled start 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 |
Description | Indicates the units of time in which the start date time offset is expressed. |
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 |
Description | The date and time when a particular staff member is required for the appointment. |
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 |
| Business Data Model Data Model |