Entity Person Organization Unit

DescriptionThe work unit assignment for each person of interest such as employee or provider.

Attributes
Assignment TypeAssignment Type

Relationship
Person Organization Unit_Person_FKPerson Organization Unit_Person_FK

Dependencies
 NONE

Reverse Dependencies
 

Attribute Details

 Assignment Type
DescriptionIdentifies the type of provider department.

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

Relationship Details

 Person Organization Unit_Person_FK
Is Identifying Relationshiptrue
Child TablePerson Organization Unit
Child MultiplicityZERO_TO_MANY
Child Referential Integrity: On DeleteNONE
Child Referential Integrity: On InsertNONE
Child Referential Integrity: On UpdateNONE
Parent TablePerson
Parent MultiplicityONE
Parent Referential Integrity: On DeleteNONE
Parent Referential Integrity: On InsertNONE
Parent Referential Integrity: On UpdateNONE