Entity Provider Service Location

DescriptionAn association between a location and an organizational unit. It is like the organizational unit location except provider service location can be assigned to a patient.

Attributes
Service TypeService Type

Relationship
Provider Service Location_Organization Unit_FKProvider Service Location_Organization Unit_FK
Provider Service Location_Location_FK1Provider Service Location_Location_FK1
Provider Service Location_Location_FKProvider Service Location_Location_FK

Dependencies
 NONE

Reverse Dependencies
 

Attribute Details

 Service Type
DescriptionIndicates the category of services provided at the location.

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

Relationship Details

 Provider Service Location_Organization Unit_FK
Is Identifying Relationshipfalse
Child TableProvider Service Location
Child Role Namebelongs to
Child MultiplicityZERO_TO_MANY
Child Referential Integrity: On DeleteNONE
Child Referential Integrity: On InsertNONE
Child Referential Integrity: On UpdateNONE
Parent TableOrganization Unit
Parent MultiplicityZERO_TO_ONE
Parent Referential Integrity: On DeleteNONE
Parent Referential Integrity: On InsertNONE
Parent Referential Integrity: On UpdateNONE



 Provider Service Location_Location_FK1
Is Identifying Relationshiptrue
Child TableProvider Service Location
Child Role Nameroom
Child MultiplicityZERO_TO_MANY
Child Referential Integrity: On DeleteNONE
Child Referential Integrity: On InsertNONE
Child Referential Integrity: On UpdateNONE
Parent TableLocation
Parent MultiplicityONE
Parent Referential Integrity: On DeleteNONE
Parent Referential Integrity: On InsertNONE
Parent Referential Integrity: On UpdateNONE



 Provider Service Location_Location_FK
Is Identifying Relationshiptrue
Child TableProvider Service Location
Child Role Namework unit site
Child MultiplicityZERO_TO_MANY
Child Referential Integrity: On DeleteNONE
Child Referential Integrity: On InsertNONE
Child Referential Integrity: On UpdateNONE
Parent TableLocation
Parent MultiplicityONE
Parent Referential Integrity: On DeleteNONE
Parent Referential Integrity: On InsertNONE
Parent Referential Integrity: On UpdateNONE