Entity Location Specialty

DescriptionA discipline within healthcare that a location provides.

For example:
Ambulatory
Pediatric
Psychiatric
Isolation

Attributes
Location Specialty TypeLocation Specialty Type

Relationship
Location Specialty_Point Of Care Location_FKLocation Specialty_Point Of Care Location_FK

Dependencies
 NONE

Reverse Dependencies
 

Attribute Details

 Location Specialty Type
DescriptionIndicates the type of specialty available at a location.

For example:
Psychiatric
Emergency
Observation
Education
Data TypeStandards - Data Domains.ddm/Data Domains/Enumeration [VARCHAR(20)]
Is Part Of PrimaryKeyfalse
Is Requiredtrue
Is Derivedfalse
Is Surrogate Keyfalse

Relationship Details

 Location Specialty_Point Of Care Location_FK
Is Identifying Relationshiptrue
Child TableLocation Specialty
Child Role Nameis available at
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