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 add-in 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 /* A preview of the instance */
}]

AdditionalNationalities_Aggregate

[{
  descriptor: Text /* A preview 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 /* A preview of the instance */
      id: Text /* Id of the instance */
  }
  description: Text /* Description for the Citizenship Status. */
  descriptor: Text /* A preview 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 /* A preview 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 /* A preview of the instance */
  disability: { /* The \~Disability\~ for a \~Disability\~ Status. */
      descriptor: Text /* A preview 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 /* A preview 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 /* A preview of the instance */
  location: { /* The country or country region for an Ethnicity. */
      descriptor: Text /* A preview of the instance */
  }
}]

Ethnicities_Aggregate

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

MilitaryServices_Aggregate

[{
  begin: Date /* The Military Status Begin Date for the Military Service. */
  descriptor: Text /* A preview of the instance */
  discharge: Date /* The Discharge Date for the Military Service. */
  militaryDischargeTypeReference: { /* The Military Service.has Military Discharge Type reference. */
      descriptor: Text /* A preview 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 /* A preview of the instance */
  }
  notes: Rich Text /* Notes associated with the Military Service. */
  rank: { /* The Military Rank for the Military Service. */
      descriptor: Text /* A preview 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 /* A preview of the instance */
          id: Text /* Id of the instance */
      }
      description: Text /* The military status description. */
      descriptor: Text /* A preview of the instance */
  }
  type: { /* Military Service Type for Military Service */
      descriptor: Text /* A preview of the instance */
  }
}]

RelativeNames_Aggregate

[{
academicSuffix: { /* The academic suffix for a relative name. */
descriptor: Text /* A preview of the instance */
}
country: { /* The country from the relative name. */
descriptor: Text /* A preview of the instance */
id: Text /* Id of the instance */
}
descriptor: Text /* A preview 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 /* A preview of the instance */
}
honorarySuffix: { /* The honorary suffix for a relative name. */
descriptor: Text /* A preview of the instance */
}
lastName: Text /* The family name for a relative name. */
localPersonName: { /* The Local Person Name instance for a relative name. */
descriptor: Text /* A preview 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 /* A preview of the instance */
}
relativeType: { /* The relative type for a relative name. */
descriptor: Text /* A preview of the instance */
}
religiousSuffix: { /* The religious suffix for a relative name. */
descriptor: Text /* A preview of the instance */
}
royalSuffix: { /* The royal suffix for a relative name. */
descriptor: Text /* A preview of the instance */
}
salutationSuffix: { /* The salutation from a relative name. */
descriptor: Text /* A preview of the instance */
}
secondaryLastName: Text /* The secondary family name for a relative name */
socialSuffix: { /* The social suffix for a relative name. */
descriptor: Text /* A preview of the instance */
}
title: { /* The prefix for a relative name. */
descriptor: Text /* A preview of the instance */
}
}]

Religion_Aggregate

[{
  descriptor: Text /* A preview of the instance */
}]

SexualOrientationAndGenderIdentity_Aggregate

[{
  descriptor: Text /* A preview of the instance */
}]

VeteransPreference_Aggregate

[{
  descriptor: Text /* A preview 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	A textual representation or label for the person's aboriginal or indigenous identification details.
ActiveMilitaryUniformedService_Descriptor	String	A description or label indicating a person's active service in a military or uniformed service.
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	A textual representation of a person's blood type, typically used for medical records and emergency situations.
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	A descriptive label indicating a person’s gender as recorded in the system.
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	A descriptive label indicating the current marital status of a person, such as 'Single' or 'Married'.
MaritalStatus_Status_Location_Descriptor	String	A textual representation of the jurisdiction or location where the person's marital status was recorded or recognized.
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	A textual representation of the country where the person was born.
PlaceOfBirth_Country_Id	String	A unique identifier assigned to the country where the person was born.
PlaceOfBirth_Region_Descriptor	String	A textual representation of the region, state, or province where the person was born.
PlaceOfBirth_Region_Id	String	A unique identifier assigned to the region, state, or province where the person was born.
PoliticalAffiliation_Descriptor	String	A descriptive label representing the person’s political affiliation, if recorded.
PrimaryNationality_Descriptor	String	A textual representation of the primary nationality held by the person.
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	A textual representation of a person’s Selective Service registration status, relevant for military conscription or eligibility.
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	A textual representation of the social benefits locality associated with a person.
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	A textual representation of the location associated with the person's social benefits locality.
SocialBenefitsLocality_Name	String	The name of the locality where a person’s social benefits apply.
UniformServiceReserveStatus_Descriptor	String	A textual representation of a person's reserve status in a uniformed service.
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	A textual representation of a person's veterans' preference for Reduction in Force (RIF) situations.
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.

Excel Add-In for Workday