Entity Party Email

DescriptionAn email address used by the party (patient, organization, facility and so on).

Attributes
Contact Email TypeContact Email Type
Contact InstructionsContact Instructions
Contact Preference PriorityContact Preference Priority
Contact UseContact Use
Email Address DescrEmail Address Descr
Validity Check DateValidity Check Date
Validity Check ResultValidity Check Result

Relationship
Party Email_Email Address_FKParty Email_Email Address_FK
Party Email_Role Player_FKParty Email_Role Player_FK

Dependencies
 NONE

Reverse Dependencies
 

Attribute Details

 Contact Email Type
DescriptionIndicates the nature of the email address.

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



 Contact Instructions
DescriptionAny recorded advice which may be helpful when contacting the party using this email address.

For example:
Shared address, do not include sensitive information.
Data TypeStandards - Data Domains.ddm/Data Domains/Text Medium [VARCHAR(255)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Contact Preference Priority
DescriptionIndicates the relative priority of the email address with respect to other email addresses used by the party.

For example:
1 (Main/primary preference)
5 (Low preference)
Data TypeStandards - Data Domains.ddm/Data Domains/Enumeration [VARCHAR(20)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Contact Use
DescriptionIndicates the way an email address is used by a party.

For example:
Default
Mailing
Billing
Delivery
Statement
Alert Contact
After Hours
Data TypeStandards - Data Domains.ddm/Data Domains/Enumeration [VARCHAR(20)]
Is Part Of PrimaryKeyfalse
Is Requiredtrue
Is Derivedfalse
Is Surrogate Keyfalse



 Email Address Descr
DescriptionAn email address string, representing the party's email address.
Data TypeStandards - Data Domains.ddm/Data Domains/Description [VARCHAR(250)]
Is Part Of PrimaryKeyfalse
Is Requiredtrue
Is Derivedfalse
Is Surrogate Keyfalse



 Validity Check Date
DescriptionThe date upon which the validity of the contact preference was last checked.
Data TypeStandards - Data Domains.ddm/Data Domains/Date [DATE]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Validity Check Result
DescriptionIndicates the conclusion of the most recent validity check.

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

Relationship Details

 Party Email_Email Address_FK
Is Identifying Relationshiptrue
Child TableParty Email
Child MultiplicityZERO_TO_MANY
Child Referential Integrity: On DeleteNONE
Child Referential Integrity: On InsertNONE
Child Referential Integrity: On UpdateNONE
Parent TableEmail Address
Parent MultiplicityONE
Parent Referential Integrity: On DeleteNONE
Parent Referential Integrity: On InsertNONE
Parent Referential Integrity: On UpdateNONE



 Party Email_Role Player_FK
Is Identifying Relationshipfalse
Child TableParty Email
Child Role Nameemail used
Child MultiplicityZERO_TO_MANY
Child Referential Integrity: On DeleteNONE
Child Referential Integrity: On InsertNONE
Child Referential Integrity: On UpdateNONE
Parent TableRole Player
Parent Role Nameuses email
Parent MultiplicityZERO_TO_ONE
Parent Referential Integrity: On DeleteNONE
Parent Referential Integrity: On InsertNONE
Parent Referential Integrity: On UpdateNONE