Business Data Model Data Model

Entity

Entity Appointment Resource Equipment

Description

An equipment resource that can be scheduled for an appointment.

For example:
Electrocardiogram Machine
Ultrasound Machine
Electroencephalogram

Attributes
Allow Equipment Substitution Indicator
Appointment Resource Code
Duration
Duration Unit Of Measure
Equipment Resource Type
Filler Status
Resource Qty
Resource Quantity Unit
Start Date Time Offset
Start Date Time Offset Unit
Start Date Time Ts

Dependencies
NONE

Reverse Dependencies

Description	An indicator that shows whether the identified equipment can be substituted with equivalent equipment. For example: No - Substitution of this resource is not allowed. Confirm - Contact the placer contact person before replacing this resource. Notify - Notify the placer contact person through normal institutional procedures that a substitution of this resource has been made. Yes - Substitution of this resource 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	Indicates the resource being requested or scheduled for an 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	The duration for which the resource 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 the resource 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 resource is required for the full duration of the appointment. This field must be a positive, nonzero number.
Data Type	Standards - Data Domains.ddm/Data Domains/Number Decimal Small [DECIMAL(5,2)]
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	Indicates the type of equipment that should be scheduled by the filler.
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	The quantity of the specified equipment.
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 the equipment requested.
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 equipment 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 equipment 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

Entity

Business Data Model Data Model