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.

Columns

This view returns the following 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