Entity Plan Member Practitioner

DescriptionThe relationship between a member and their healthcare practitioners.

Attributes
PCP IndPCP Ind

Relationship
Member Practitioner_Practitioner_FKMember Practitioner_Practitioner_FK
Member Practitioner_Member_FKMember Practitioner_Member_FK

Dependencies
 NONE

Reverse Dependencies
 

Attribute Details

 PCP Ind
DescriptionIndication if the practitioner is the primary care physician for a member.
Data TypeStandards - Data Domains.ddm/Data Domains/Boolean Indicator [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse

Relationship Details

 Member Practitioner_Practitioner_FK
Is Identifying Relationshiptrue
Child TablePlan Member Practitioner
Child MultiplicityZERO_TO_MANY
Child Referential Integrity: On DeleteNONE
Child Referential Integrity: On InsertNONE
Child Referential Integrity: On UpdateNONE
Parent TablePractitioner
Parent MultiplicityONE
Parent Referential Integrity: On DeleteNONE
Parent Referential Integrity: On InsertNONE
Parent Referential Integrity: On UpdateNONE



 Member Practitioner_Member_FK
Is Identifying Relationshiptrue
Child TablePlan Member Practitioner
Child MultiplicityZERO_TO_MANY
Child Referential Integrity: On DeleteNONE
Child Referential Integrity: On InsertNONE
Child Referential Integrity: On UpdateNONE
Parent TableInsured
Parent MultiplicityONE
Parent Referential Integrity: On DeleteNONE
Parent Referential Integrity: On InsertNONE
Parent Referential Integrity: On UpdateNONE