Entity Medical Equipment

DescriptionA personal health observation that describes a patient's medical equipment history. This may include details of equipment used during hospital stays or at home.

For example:
Infusion pump
Blood pressure machine
Electric wheelchair

Attributes
Availability Duration QtyAvailability Duration Qty
Availability Duration Unit of MeasureAvailability Duration Unit of Measure
Device Identification NumDevice Identification Num
Device QtyDevice Qty
Device TypeDevice Type
Medical Equipment StatusMedical Equipment Status

Relationship
Equipment_Patient_FKEquipment_Patient_FK
Medical Equipment_Functional Status_FKMedical Equipment_Functional Status_FK

Generalization
Generalization1Generalization1

Dependencies
 NONE

Reverse Dependencies
 

Attribute Details

 Availability Duration Qty
DescriptionThe duration for which the medical device is available.
Data TypeStandards - Data Domains.ddm/Data Domains/Number Decimal Small [DECIMAL(5,2)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Availability Duration Unit of Measure
DescriptionThe units of measure in which Availability Duration Qty is expressed.

For example:
Minutes
Hours
Days
Weeks
Data TypeStandards - Data Domains.ddm/Data Domains/Enumeration [VARCHAR(20)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Device Identification Num
DescriptionA number by which the device may be identified. May be an organization's internal asset number or a manufacturer's serial number or some other reference number.
Data TypeStandards - Data Domains.ddm/Data Domains/Alphanumeric [VARCHAR(80)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Device Qty
DescriptionA count of the number of devices.
Data TypeStandards - Data Domains.ddm/Data Domains/Quantity Integer [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Device Type
DescriptionIndicates the category of the device.

For example:
Infusion pump
Monitor
Data TypeStandards - Data Domains.ddm/Data Domains/Enumeration [VARCHAR(20)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Medical Equipment Status
DescriptionDescribes the status of medical equipment.
Data TypeStandards - Data Domains.ddm/Data Domains/Enumeration [VARCHAR(20)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse

Relationship Details

 Equipment_Patient_FK
Is Identifying Relationshiptrue
Child TableMedical Equipment
Child MultiplicityZERO_TO_MANY
Child Referential Integrity: On DeleteNONE
Child Referential Integrity: On InsertNONE
Child Referential Integrity: On UpdateNONE
Parent TablePatient
Parent MultiplicityONE
Parent Referential Integrity: On DeleteNONE
Parent Referential Integrity: On InsertNONE
Parent Referential Integrity: On UpdateNONE



 Medical Equipment_Functional Status_FK
Is Identifying Relationshipfalse
Child TableMedical Equipment
Child Role Namenon medicinal equipment
Child MultiplicityZERO_TO_MANY
Child Referential Integrity: On DeleteNONE
Child Referential Integrity: On InsertNONE
Child Referential Integrity: On UpdateNONE
Parent TableFunctional Status
Parent MultiplicityZERO_TO_ONE
Parent Referential Integrity: On DeleteNONE
Parent Referential Integrity: On InsertNONE
Parent Referential Integrity: On UpdateNONE

Generalization Details

 Generalization1
SupertypePersonal Health Observation
SubtypeMedical Equipment
Transform AsTABLE