Power BI Connector for Workday

Build 25.0.9454

PeoplePersonalInformation

Stores various personal attributes of an individual, such as birthdate, gender, marital status, and nationality, for Human Resources (HR) and compliance purposes.

Workday Resource Information

Retrieves all personal information for the person with the specified ID.

Secured by: Person Data: Personal Information, Self-Service: Personal Information

Scope: Personal Data

Aggregate Fields

The connector represents the following fields as aggregates containing JSON text. Each of them conforms to their respective schema. Fields marked with an asterisk are required and must be included if their parent object is. Fields marked with a hyphen are read-only and must not be included when calling stored procedures or when performing an INSERT or UPDATE.

This information is derived from the Workday REST API specification which does not explicitly list all business rules and validations that apply to each object. More fields may be required than what is listed here.

AboriginalIndigenousIdentificationDetails_Aggregate


[{
  descriptor: Text /* The display name of the instance */
}]

AdditionalNationalities_Aggregate


[{
  descriptor: Text /* The display name of the instance */
  id: Text /* Id of the instance */
}]

CitizenshipStatuses_Aggregate


[{
  citizen: Boolean /* Identifies Citizenship Status as citizen. */
  country: { /* Country for the Citizenship Status. */
      descriptor: Text /* The display name of the instance */
      id: Text /* Id of the instance */
  }
  description: Text /* Description for the Citizenship Status. */
  descriptor: Text /* The display name of the instance */
  inactive: Boolean /* True if the Citizenship Status is inactive. */
  name: Text /* Name for the Citizenship Status. */
}]

DisabilityStatuses_Aggregate


[{
  accommodationProvided: Text /* The Accommodations Provided for a \~Disability\~ status. */
  accommodationRequested: Text /* The Accommodations Requested for a \~Disability\~ status. */
  certificationBasis: { /* The Certification Basis for a \~Disability\~ status. */
      descriptor: Text /* The display name of the instance */
  }
  certificationID: Text /* The Certification ID for a \~Disability\~ status. */
  certifiedAt: Text /* The Certification Location for a \~Disability\~ status. */
  certifiedBy: Text /* The \~Disability\~ Authority for a \~Disability\~ Status */
  degreePercent: Numeric /* The Degree for a \~Disability\~ status. */
  descriptor: Text /* The display name of the instance */
  disability: { /* The \~Disability\~ for a \~Disability\~ Status. */
      descriptor: Text /* The display name of the instance */
  }
  endDate: Date /* The End Date for a \~Disability\~ status. */
  fteTowardQuota: Numeric /* The FTE Toward Quota for a \~Disability\~ status. */
  grade: { /* The Grade for a \~Disability\~ status. */
      descriptor: Text /* The display name of the instance */
  }
  knownDate: Date /* The Date Known for a \~Disability\~ status. */
  note: Text /* The Note for a \~Disability\~ status. */
  rehabilitationProvided: Text /* The Rehabilitation Provided for a \~Disability\~ status. */
  rehabilitationRequested: Text /* The Rehabilitation Requested for a \~Disability\~ status. */
  remainingCapacity: Numeric /* The Remaining Capacity for a \~Disability\~ status. */
  severityRecognitionDate: Date /* The Severity Recognition Date for a \~Disability\~ status. */
  statusDate: Date /* The \~Disability\~ Status Date for a \~Disability\~ Status. */
  statusID: Text /* The reference id for the \~disability\~ status.  This is the unique identifier for the \~disability\~ status that is assigned at creation and then maintained throughout its life as it is edited. */
  workRestrictions: Text /* The Work Restrictions for a \~Disability\~ status. */
  workerDocuments: [{
      comment: Text /* The additional comments associated with the Worker Document. */
      fileName: Text /* The filename of the Worker Document. */
  }]
}]

EthnicitiesForVisualSurvey_Ethnicities_Aggregate


[{
  descriptor: Text /* The display name of the instance */
  location: { /* The country or country region for an Ethnicity. */
      descriptor: Text /* The display name of the instance */
  }
}]

Ethnicities_Aggregate


[{
  descriptor: Text /* The display name of the instance */
  location: { /* The country or country region for an Ethnicity. */
      descriptor: Text /* The display name of the instance */
  }
}]

MilitaryServices_Aggregate


[{
  begin: Date /* The Military Status Begin Date for the Military Service. */
  descriptor: Text /* The display name of the instance */
  discharge: Date /* The Discharge Date for the Military Service. */
  militaryDischargeTypeReference: { /* The Military Service.has Military Discharge Type reference. */
      descriptor: Text /* The display name of the instance */
      id: Text /* Id of the instance */
  }
  militaryServiceReference: { /* The reference id for the military service entry.  This is the unique identifier for the military service that is assigned at creation and then maintained throughout its life as it is edited. */
      descriptor: Text /* The display name of the instance */
  }
  notes: Rich Text /* Notes associated with the Military Service. */
  rank: { /* The Military Rank for the Military Service. */
      descriptor: Text /* The display name of the instance */
  }
  status: { /* The \~Military Status\~ for the Military Service. */
      code: Text /* The \~military status\~ code. */
      country: { /* The country for the Military Status. */
          descriptor: Text /* The display name of the instance */
          id: Text /* Id of the instance */
      }
      description: Text /* The military status description. */
      descriptor: Text /* The display name of the instance */
  }
  type: { /* Military Service Type for Military Service */
      descriptor: Text /* The display name of the instance */
  }
}]

RelativeNames_Aggregate


[{
  academicSuffix: { /* The academic suffix for a relative name. */
      descriptor: Text /* The display name of the instance */
  }
  country: { /* The country from the relative name. */
      descriptor: Text /* The display name of the instance */
      id: Text /* Id of the instance */
  }
  descriptor: Text /* The display name of the instance */
  firstName: Text /* The first or given name for a relative name. */
  fullName: Text /* The Full Name for a relative name, where provided. Workday only tracks Full Name for countries where the Full Name name component is used. */
  hereditarySuffix: { /* The hereditary suffix for a relative name. */
      descriptor: Text /* The display name of the instance */
  }
  honorarySuffix: { /* The honorary suffix for a relative name. */
      descriptor: Text /* The display name of the instance */
  }
  lastName: Text /* The family name for a relative name. */
  localPersonName: { /* The Local Person Name instance for a relative name. */
      descriptor: Text /* The display name of the instance */
      first: Text /* The person's given name in local script.  Workday only tracks local names for countries where a non-Latin script is commonly used. */
      first2: Text /* The person's given name in second local script.  Workday only tracks local names for countries where a non-Latin script is commonly used. */
      last: Text /* The person's last name in local script.  Workday only tracks local names for countries where a non-Latin script is commonly used. */
      last2: Text /* The person's last name in second local script.  Workday only tracks local names for countries where a non-Latin script is commonly used. */
      middle: Text /* The person's middle name in local script.  Workday only tracks local names for countries where a non-Latin script is commonly used. */
      middle2: Text /* The person's second middle name in local script.  Workday only tracks local names for countries where a non-Latin script is commonly used. */
      secondaryLast: Text /* The person's secondary family name in local script.  Workday only tracks local names for countries where a non-Latin script is commonly used. */
      secondaryLast2: Text /* The person's secondary last name in second local script.  Workday only tracks local names for countries where a non-Latin script is commonly used. */
  }
  middleName: Text /* The middle name for a relative name. */
  professionalSuffix: { /* The professional suffix for a relative name. */
      descriptor: Text /* The display name of the instance */
  }
  relativeType: { /* The relative type for a relative name. */
      descriptor: Text /* The display name of the instance */
  }
  religiousSuffix: { /* The religious suffix for a relative name. */
      descriptor: Text /* The display name of the instance */
  }
  royalSuffix: { /* The royal suffix for a relative name. */
      descriptor: Text /* The display name of the instance */
  }
  salutationSuffix: { /* The salutation from a relative name. */
      descriptor: Text /* The display name of the instance */
  }
  secondaryLastName: Text /* The secondary family name for a relative name */
  socialSuffix: { /* The social suffix for a relative name. */
      descriptor: Text /* The display name of the instance */
  }
  title: { /* The prefix for a relative name. */
      descriptor: Text /* The display name of the instance */
  }
}]

Religion_Aggregate


[{
  descriptor: Text /* The display name of the instance */
}]

SexualOrientationAndGenderIdentity_Aggregate


[{
  descriptor: Text /* The display name of the instance */
}]

VeteransPreference_Aggregate


[{
  descriptor: Text /* The display name of the instance */
  id: Text /* Id of the instance */
  inactive: Boolean /* The Inactive flag. */
  militaryServicePreferenceCode: Text /* Military Service Preference Code */
  militaryServicePreferenceDescription: Text /* Military Service Preference Description */
  militaryServicePreferenceName: Text /* \~Veteran's Preference\~ Category */
}]

Columns

Name Type Description
People_Id String The unique Workday ID (WID) assigned to a person, which links their personal records across the system.
AboriginalIndigenousIdentificationDetails_Aggregate String Provides detailed information about a person's self-identified aboriginal or indigenous status, including any supporting documentation or classifications.
AboriginalIndigenousIdentification_Descriptor String The display name of the instance
ActiveMilitaryUniformedService_Descriptor String The display name of the instance
ActiveMilitaryUniformedService_Id String The unique identifier representing a specific military or uniformed service status in Workday.
AdditionalNationalities_Aggregate String A list of additional nationalities that a person holds, beyond their primary nationality. This can include dual or multiple citizenships.
BloodType_Descriptor String The display name of the instance
CitizenshipStatuses_Aggregate String Details regarding a person’s citizenship status, including residency and naturalization information.
DateOfBirth Datetime The official recorded birth date of the person, used for identification and age-based calculations.
DateOfDeath Datetime The official recorded date of death for a person, if applicable, used for records management and compliance tracking.
DisabilityStatuses_Aggregate String A collection of disability status records associated with a person, including official classifications and accommodations.
DisabledVeteranLeaveDate Datetime The effective date from which a veteran's disability-related leave or benefits take effect.
EthnicitiesForVisualSurvey_Ethnicities_Aggregate String A list of ethnicities a person has self-reported in a visual survey, used for demographic analysis and reporting.
EthnicitiesForVisualSurvey_HispanicOrLatinoForVisualSurvey Bool Indicates whether the person has self-identified as Hispanic or Latino for a visual survey. Returns 'true' if applicable.
Ethnicities_Aggregate String A list of ethnicities self-reported by a person, often used for compliance and demographic reporting.
Gender_Descriptor String The display name of the instance
HispanicOrLatino Bool Indicates whether the person has self-identified as Hispanic or Latino. Returns 'true' if applicable.
MaritalStatus_Date Datetime The date when a person’s marital status was last updated, reflecting significant life changes such as marriage or divorce.
MaritalStatus_Status_Descriptor String The display name of the instance
MaritalStatus_Status_Location_Descriptor String The display name of the instance
MedicalExam_ExpirationDate Datetime The expiration date of the most recent medical examination, often relevant for employment or health compliance.
MedicalExam_LastExamDate Datetime The date on which the person's most recent medical examination was conducted.
MedicalExam_Notes String Additional notes and observations recorded during a person's medical examination.
MilitaryServices_Aggregate String A collection of military service records associated with a person, including service periods, branches, and statuses.
PlaceOfBirth_City String The name of the city where the person was born, as recorded in official documentation.
PlaceOfBirth_Country_Descriptor String The display name of the instance
PlaceOfBirth_Country_Id String A unique identifier assigned to the country where the person was born.
PlaceOfBirth_Region_Descriptor String The display name of the instance
PlaceOfBirth_Region_Id String A unique identifier assigned to the region, state, or province where the person was born.
PoliticalAffiliation_Descriptor String The display name of the instance
PrimaryNationality_Descriptor String The display name of the instance
PrimaryNationality_Id String A unique identifier assigned to the person's primary nationality.
RelativeNames_Aggregate String A list of names of a person’s relatives, as recorded in the system for reference or contact purposes.
Religion_Aggregate String A collection of religious affiliations or beliefs that the person has recorded, if applicable.
SelectiveServiceRegistration_Descriptor String The display name of the instance
SelectiveServiceRegistration_Id String A unique identifier assigned to the person's Selective Service registration record.
SexualOrientationAndGenderIdentity_Aggregate String A collection of records detailing a person's self-reported sexual orientation and gender identity.
SocialBenefitsLocality_Code String The official code representing the locality where a person is eligible for social benefits.
SocialBenefitsLocality_Description String A detailed description of the locality where a person’s social benefits are applicable.
SocialBenefitsLocality_Descriptor String The display name of the instance
SocialBenefitsLocality_Inactive Bool Indicates whether the social benefits locality is currently inactive. Returns 'true' if the locality is no longer valid.
SocialBenefitsLocality_Location_Descriptor String The display name of the instance
SocialBenefitsLocality_Name String The name of the locality where a person’s social benefits apply.
UniformServiceReserveStatus_Descriptor String The display name of the instance
UniformServiceReserveStatus_Id String A unique identifier assigned to the person’s uniformed service reserve status record.
UniformServiceReserveStatus_Inactive Bool Indicates whether the person’s uniformed service reserve status is inactive. Returns 'true' if inactive.
UniformServiceReserveStatus_UniformServiceReserveStatusCode String The official code representing a specific uniformed service reserve status.
UniformServiceReserveStatus_UniformServiceReserveStatusDescription String A detailed description of the uniformed service reserve status assigned to a person.
UniformServiceReserveStatus_UniformServiceReserveStatusName String The official name of the uniformed service reserve status assigned to a person.
VeteransPreferenceForRIF_Descriptor String The display name of the instance
VeteransPreferenceForRIF_Id String A unique identifier assigned to the veteran's preference for RIF status.
VeteransPreference_Aggregate String A collection of records detailing a person’s veteran's preference status, including eligibility for hiring preferences.
Country_Prompt String Specifies the country for which personal information should be retrieved. If left blank, the most recently updated personal information set will be used.
Universal_ID_Prompt String The unique Universal ID associated with the person whose personal information is being requested.

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