Invenias Power BI: People Contact Details

The People Contact Details simplifies communication and data management by centralizing diverse contact details, ensuring a holistic view of an individual's most relevant and up-to-date contact information.

What It Does

• Extensive Contact Options: Gather all contact information such as multiple phone numbers (home, mobile, direct line, car phone, pager, etc), emails, and custom contact fields,
• Customized Phone and Email Fields: Customize phone and email fields to cater to your unique contact information requirements.
• Primary Telephone Selection Logic: Pull the most relevant contact number based with the predetermined index.

Table of Columns

Column Name	Column Type	Description	Joins To
PersonId	Guid	The unique identifier for the person.	PeopleView
HomePhone	String	Primary home phone number.	N/A
MobilePhone	String	Primary mobile phone number.	N/A
DirectLine	String	Direct telephone line, if available.	N/A
OtherPhone	String	Additional phone numbers (car phone, pager, ISDN, etc.).	N/A
CustomPhone1-5	String	Custom phone fields for additional numbers.	N/A
PrimaryTelephone	String	The most relevant telephone number based on a priority system.	N/A
CustomEmail1-5	String	Custom email fields for additional addresses.	N/A
Email1-3	String	Standard email addresses.	N/A
Email1-3Type	String	Classification of email addresses as personal or business.	N/A