Entity Location Accommodation

DescriptionA description of the accommodation for a given location that is associated with a billing rate.

For example:
Private room
Semi-private room

Attributes
Accommodation TypeAccommodation Type

Relationship
Location Accommodation Type_Point Of Care Location_FKLocation Accommodation Type_Point Of Care Location_FK

Dependencies
 NONE

Reverse Dependencies
 

Attribute Details

 Accommodation Type
DescriptionThe type of accommodation within a healthcare facility.
Data TypeStandards - Data Domains.ddm/Data Domains/Enumeration [VARCHAR(20)]
Is Part Of PrimaryKeyfalse
Is Requiredtrue
Is Derivedfalse
Is Surrogate Keyfalse

Relationship Details

 Location Accommodation Type_Point Of Care Location_FK
Is Identifying Relationshiptrue
Child TableLocation Accommodation
Child Role Nameimpacts billing rate
Child MultiplicityZERO_TO_MANY
Child Referential Integrity: On DeleteNONE
Child Referential Integrity: On InsertNONE
Child Referential Integrity: On UpdateNONE
Parent TablePoint Of Care Location
Parent MultiplicityONE
Parent Referential Integrity: On DeleteNONE
Parent Referential Integrity: On InsertNONE
Parent Referential Integrity: On UpdateNONE