Power BI Connector for Salesforce Data Cloud

Build 24.0.9175

Individual

The Individual DMO is a Data Cloud data model object for contacts,customers, or other people interested in your company's products or services.

Columns

Name Type References Description
Birth Date Datetime A person’s birth date including year, month, and date.
Birth Date Day Double The day the individual was born.
Birth Date Month Double The month the individual was born.
Birth Date Year Double The year the individual was born.
Birth Place Varchar The location the person was born.
Block Geolocation Tracking Varchar An indicator if the individual has opted out of geolocationtracking.
Children Count Double The number of children the person has.
Consumer Credit Score Double The individual’s consumer credit score.
Consumer Credit Score Provider Name Double The provider of the individual’s consumer credit score.
Convictions Count Double The number of convictions the individual has.
Created Date Datetime The date when the record was created.
Current Employer Name Varchar The name of the person’s current employer.
Data Source Varchar Thereference ID for the logical name for a system that is the source ofrecords identified by external record ID.
Data Source Object Varchar The reference ID for the logical name of the object where thisrecord came from, whether that is a name of a cloud storage file oranother connector’s external object.
Death Date Datetime The date the person died.
Death Place Varchar The location of the person’s death.
Dependent Count Double The number of dependents a person claims.
Do Extract My Data Update Date Datetime The update date to extract an individual’s data.
Do Forget Me Update Date Datetime The update date to forget an individual’s data.
Do Not Market Update Date Datetime The update date to not market an individual’s data.
Do Not Process Varchar An indicator if the individual has opted out ofprocessing.
Do Not Process Reason Varchar A reference ID for the reason the individual has opted out ofprocessing.
Do Not Process Update Date Datetime The update date to not process an individual’s data.
Do Not Profile Varchar An indicator if the individual has opted out ofprofiling.
Do Not Profile Update Date Datetime The update date to not profile an individual’s data.
Do Not Solicit Varchar An indicator if the individual has opted out ofsoliciting.
Do Not Track Varchar An indicator if the individual has opted out of tracking.
Do Not Track Location Update Date Datetime The update date to not track an individual’s location.
Do Not Track Update Date Datetime The update date to not track an individual’s data.
Employed Since Date Datetime The date the person was hired at their current employer.
Ethnicity Varchar A reference ID for the individual’s ethnicity.
Export Individual’s Data Varchar An indicator to export the individual’s data.
External Record ID Varchar The reference ID for an external data source system.
External Source ID Varchar The reference ID for the system in which the external record IDwas assigned.
First Name Varchar A person’s first name.
Forget This Individual Varchar An indicator to forget the individual’s data.
Gender Varchar The reference ID for the person’s gender.
Gender Identity Varchar The gender identity of the individual.
Global Party Varchar A reference ID to the global party, for example, an individual,business, or affiliation group.
Has Alcohol Abuse History Varchar An indicator if the individual has a history of alcoholabuse.
Has Drug Abuse History Varchar An indicator if the individual has a history of drugabuse.
Highest Education Level Varchar The reference ID to the person’s highest completed educationlevel, for example high school or PhD.
Hospitalizations Last 5 Years Count Varchar The number of hospitalizations the individual has had in the last5 years.
Individual ID Varchar A unique ID used as the primary key for the individualDMO.
Influencer Rating Varchar The rating given to a person based on their influence, typicallyin social media.
Internal Organization Varchar The reference ID to the business unit or other internalorganization that owns the business account.
Is Alcohol Consumer Varchar An indicator if the individual consumes alcohol.
Is Anonymous Varchar An indicator that the person wishes to remain anonymous.
Is Drug Consumer Varchar An indicator if the individual consumes drugs.
Is Good Driver Varchar An indicator if the individual is a good driver.
Is Good Student Varchar An indicator if the individual is a good student.
Is High Risk Hobby Varchar An indicator if the individual has a high risk hobby.
Is High Risk Occupation Varchar An indicator if the individual has a high riskoccupation.
Is Home Owner Varchar An indicator that the person owns a home.
Is Tobacco Consumer Varchar An indicator if the individual consumes tobacco.
Last Modified Date Datetime The date when a user last modified the record.
Last Name Varchar The person’s last name.
Mailing Name Varchar The person’s full name used for mailing purposes, for example Dr.Jane Doe.
Main Dietary Habit Type Varchar A reference ID to the individual’s main dietary habittype.
Main Disability Type Varchar A reference ID to the individual’s main disability type.
Main Life Attitude Type Varchar A reference ID to the individual’s main life attitudetype.
Main Life Style Type Varchar A reference ID to the individual’s main life style type.
Main Personal Value Type Varchar A reference ID to the individual’s main personal valuetype.
Main Personality Type Varchar A reference ID to the individual’s main personality type.
Major Citation Count Double The number of major citations the individual has.
Marital Status Varchar A reference ID for a person’s marital status.
Middle Name Varchar A person’s middle name.
Military Service Varchar A reference ID showing if the person served in themilitary.
Military Status Varchar A reference ID for a person’s military status, for exampleretired or active duty.
Minor Citation Count Double The number of minor citations the individual has.
Mothers Maiden Name Varchar The unmarried last name of a person’s mother.
Name Suffix Varchar The suffix of a person’s name, for example, Jr.
Net Worth Double The net worth of the individual.
No Merge Reason Varchar A reference ID to the reason not to merge the individual’sdata.
Occupation Varchar A description of the person’s job.
Occupation Type Varchar A reference ID for the type of job a person has for exampleprofessional or student.
Official Name Varchar A person’s legal name used in communications.
OK to Store Pll Data Elsewhere Varchar An indicator if the individual’s Pll data can be storedelsewhere.
Ordering Name Varchar The name used when sorting people in a list, often alphabeticalfor example, Doe J.
Origin Country Varchar A reference ID to the individual’s country of origin.
Over Age Double The over age number of the individual.
Party Type Varchar A reference ID for the type of party, for example, individual orhousehold.
Party Additional Names Varchar The additional names associated with the individual.
Party Roles Varchar The role of an individual for example a customer, supplier, orcompetitor.
Party Web Addresses Varchar
Person Name Varchar A person’s full name.
Person Education Varchar Any associated educations for the individual.
Person Height Double The height of the individual.
Person Height Unit of Measure Varchar A reference ID to the unit of measurement of an individual’sheight.
Person Employment Varchar Any associated employments for the individual.
Person Language Varchar Any associated languages for the individual.
Person Life Events Varchar Any associated life events for the individual.
Person Life Stage Varchar The life stage of the individual.
Person Weight Double The weight of the individual.
Person Weight Unit of Measure Varchar A reference ID to the unit of measurement of an individual’sweight.
Photo URL Varchar A link to an individual’s photo.
Preferred Name Varchar A person’s preferred name.
Primary Account Varchar A reference ID for person’s account.
Primary Citizenship Country Varchar A reference ID to the individual’s primary country ofcitizenship.
Primary Hobby Varchar A reference ID for a person’s primary hobby.
Primary Household Varchar A reference ID for a person’s household.
Primary Language Varchar A reference ID for a person’s first language.
Pronoun Varchar The pronouns for the individual.
Religion Varchar A reference ID to the individual’s religion.
Residence Capture Method Varchar A reference ID for how residence information wasobtained.
Residence Country Varchar A reference ID for the country where a person resides.
Residence Country Name Varchar The primary country where a person resides.
Rewards Balance Varchar A person’s balance of rewards, for example total points.
Salutation Varchar The person’s preferred greeting, for example Ms. or Mx.
Second Last Name Varchar A person’s second last name.
Secondary Citizenship Country Varchar A reference ID to the individual’s secondary country ofcitizenship.
Surgeries Last 5 Years Count Double The number of surgeries the individual has had in the last 5years.
Tax Bracket Range Varchar The tax bracket range of the individual.
Title Varchar The title of the individual.
Web Site URL Varchar The link to a person’s website.
Wedding Anniversary Date Datetime The date of a person’s wedding.
Yearly Income Double The yearly income for the individual.
Yearly Income Currency Varchar A reference ID to the currency for the individual’s yearincome.
Yearly Income Range Varchar A reference ID to the range for the individual’s yearincome.

Copyright (c) 2025 CData Software, Inc. - All rights reserved.
Build 24.0.9175