Entity Party Address

DescriptionA postal address that applies to or has applied to a party (patient, organization, facility and so on).

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

Relationship
Patient Address Address FKPatient Address Address FK
Party Address_Role Player_FKParty Address_Role Player_FK

Dependencies
 NONE

Reverse Dependencies
 

Attribute Details

 Contact Address Type
DescriptionIndicates the nature of the contact address.

For example:
Home
Office
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 at this address.

For example:
Be aware of the dog when making a house call.
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 address with respect to other 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 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



 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

 Patient Address Address FK
Is Identifying Relationshipfalse
Child TableParty Address
Child Role Nameaddress used
Child MultiplicityZERO_TO_MANY
Child Referential Integrity: On DeleteNONE
Child Referential Integrity: On InsertNONE
Child Referential Integrity: On UpdateNONE
Parent TableAddress
Parent Role Nameuses address
Parent MultiplicityONE
Parent Referential Integrity: On DeleteNONE
Parent Referential Integrity: On InsertNONE
Parent Referential Integrity: On UpdateNONE



 Party Address_Role Player_FK
Is Identifying Relationshipfalse
Child TableParty Address
Child Role Nameis address for
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 address
Parent MultiplicityONE
Parent Referential Integrity: On DeleteNONE
Parent Referential Integrity: On InsertNONE
Parent Referential Integrity: On UpdateNONE