Entity Service

DescriptionA healthcare event that involves the use, rental, purchase or supply of durable medical equipment or ancillary supports to a person.

Attributes
DescrDescr
DME Certification TypeDME Certification Type
Duration CntDuration Cnt
Duration Unit Of MeasureDuration Unit Of Measure
Insulin Dependent TypeInsulin Dependent Type
Shipped DateShipped Date

Relationship
Service_Equipment_FKService_Equipment_FK

Generalization
Generalization1Generalization1

Dependencies
 NONE

Reverse Dependencies
 

Attribute Details

 Descr
DescriptionDescriptive text for the use of this durable medical equipment or ancillary services.
Data TypeStandards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 DME Certification Type
DescriptionIndicates the type of the certification for the use of this durable medical equipment or ancillary services.
Data TypeStandards - Data Domains.ddm/Data Domains/Enumeration [VARCHAR(20)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Duration Cnt
DescriptionLength of time the durable medical equipment or ancillary services is required.
Data TypeStandards - Data Domains.ddm/Data Domains/Count [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Duration Unit Of Measure
DescriptionIndicates the unit of measure in which the duration is expressed.

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



 Insulin Dependent Type
DescriptionIndicates the nature of insulin dependence relative to this durable medical equipment or ancillary services.
Data TypeStandards - Data Domains.ddm/Data Domains/Enumeration [VARCHAR(20)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Shipped Date
DescriptionDate upon which the durable medical piece of equipment is shipped to the patient.
Data TypeStandards - Data Domains.ddm/Data Domains/Date [DATE]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse

Relationship Details

 Service_Equipment_FK
Is Identifying Relationshipfalse
Child TableService
Child Role Nameuses
Child MultiplicityZERO_TO_MANY
Child Referential Integrity: On DeleteNONE
Child Referential Integrity: On InsertNONE
Child Referential Integrity: On UpdateNONE
Parent TableEquipment
Parent Role Nameis used in
Parent MultiplicityZERO_TO_MANY
Parent Referential Integrity: On DeleteNONE
Parent Referential Integrity: On InsertNONE
Parent Referential Integrity: On UpdateNONE

Generalization Details

 Generalization1
SupertypeHealthcare Event
SubtypeService
Transform AsTABLE