Business Data Model Data Model

Entity

Entity Party Professional Service Area

Description

An area of service that is provided by a physician, clinic, hospital, center or other role player. A provider can have several of these.

Attributes
Professional Service Area

Relationship
Party Professional Service Area_Role Player_FK
Role Player Professional Service Area_Role Player_FK

Dependencies
NONE

Reverse Dependencies

Description	The name of a service that is provided by a role player. Some role players can provide more than one service. For Example: A medical practitioner can offer general and colorectal surgical service.
Data Type	Standards - Data Domains.ddm/Data Domains/Name [VARCHAR(30)]
Is Part Of PrimaryKey	false
Is Required	false
Is Derived	false
Is Surrogate Key	false

Is Identifying Relationship	true
Child Table	Party Professional Service Area
Child Role Name	specializes in professional service
Child Multiplicity	ZERO_TO_MANY
Child Referential Integrity: On Delete	NONE
Child Referential Integrity: On Insert	NONE
Child Referential Integrity: On Update	NONE
Parent Table	Role Player
Parent Role Name	has professional service area
Parent Multiplicity	ONE
Parent Referential Integrity: On Delete	NONE
Parent Referential Integrity: On Insert	NONE
Parent Referential Integrity: On Update	NONE

Is Identifying Relationship	false
Child Table	Party Professional Service Area
Child Role Name	is professional service of
Child Multiplicity	ZERO_TO_MANY
Child Referential Integrity: On Delete	NONE
Child Referential Integrity: On Insert	NONE
Child Referential Integrity: On Update	NONE
Parent Table	Role Player
Parent Role Name	provides professional service
Parent Multiplicity	ONE
Parent Referential Integrity: On Delete	NONE
Parent Referential Integrity: On Insert	NONE
Parent Referential Integrity: On Update	NONE

Entity

Business Data Model Data Model