Entity Party Phone

DescriptionA phone number that is used to contact the party (patient, organization, facility and so on).

Attributes
Contact InstructionsContact Instructions
Contact Phone TypeContact Phone Type
Contact Preference PriorityContact Preference Priority
Contact Telephone UseContact Telephone Use
Contact Text DescrContact Text Descr
Validity Check DateValidity Check Date
Validity Check ResultValidity Check Result

Relationship
Party Phone_Phone_FKParty Phone_Phone_FK
Party Telephone FKParty Telephone FK

Dependencies
 NONE

Reverse Dependencies
 

Attribute Details

 Contact Instructions
DescriptionRecorded advice that is provided when contacting the party.
Data TypeStandards - Data Domains.ddm/Data Domains/Text Medium [VARCHAR(255)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Contact Phone Type
DescriptionThe location at which or device type on which the party can be contacted.

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



 Contact Preference Priority
DescriptionThe relative priority of the phone compared to other phones 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 Telephone Use
DescriptionThe way a party uses a telephone number.

For example:
Default
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



 Contact Text Descr
DescriptionA free-form textual comments about the telephone number.
Data TypeStandards - Data Domains.ddm/Data Domains/Free Text [VARCHAR(1024)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



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



 Validity Check Result
DescriptionThe 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 Phone_Phone_FK
Is Identifying Relationshipfalse
Child TableParty Phone
Child MultiplicityZERO_TO_MANY
Child Referential Integrity: On DeleteNONE
Child Referential Integrity: On InsertNONE
Child Referential Integrity: On UpdateNONE
Parent TablePhone
Parent MultiplicityZERO_TO_ONE
Parent Referential Integrity: On DeleteNONE
Parent Referential Integrity: On InsertNONE
Parent Referential Integrity: On UpdateNONE



 Party Telephone FK
Is Identifying Relationshipfalse
Child TableParty Phone
Child Role Nametelephone 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 telephone
Parent MultiplicityONE
Parent Referential Integrity: On DeleteNONE
Parent Referential Integrity: On InsertNONE
Parent Referential Integrity: On UpdateNONE