Entity Location Characteristic

DescriptionA set of characteristics that is used to distinguish the type of patient that can be assigned to a location.

For example:
Privacy level
Level of care
Type of care

Attributes
Location Characteristic TypeLocation Characteristic Type
Location Characteristic ValueLocation Characteristic Value

Relationship
Point Of Care Location Characteristic _Point Of Care Location_FKPoint Of Care Location Characteristic _Point Of Care Location_FK

Dependencies
 NONE

Reverse Dependencies
 

Attribute Details

 Location Characteristic Type
DescriptionIndicates the type of location feature.

For example:
Privacy level
Level of care
Smoking
Licensed
Data TypeStandards - Data Domains.ddm/Data Domains/Enumeration [VARCHAR(20)]
Is Part Of PrimaryKeyfalse
Is Requiredtrue
Is Derivedfalse
Is Surrogate Keyfalse



 Location Characteristic Value
DescriptionIndicates the value for the characteristic identified by the type code.

For example:
Some characteristics have yes or no values, SMK (smoking) has values Y (this is a smoking location) or N (this is a non-smoking) location.
Other Characteristics have distinct code values, PRL (privacy level) has values such as F (Isolation), P (Private Room), S (Semi-private room).
Data TypeStandards - Data Domains.ddm/Data Domains/Enumeration [VARCHAR(20)]
Is Part Of PrimaryKeyfalse
Is Requiredtrue
Is Derivedfalse
Is Surrogate Keyfalse

Relationship Details

 Point Of Care Location Characteristic _Point Of Care Location_FK
Is Identifying Relationshiptrue
Child TableLocation Characteristic
Child Role Nameis used to describe
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