Account Attributes

The following table lists the account attributes:

Attributes

Description

Source Data Element WD Object /Field Web Service Element File field

USERID

Worker ID of the worker

Worker_Data/User_ID

FILENUMBER

Employee ID of the worker

Worker_Data/Worker_ID

MANAGER

Current manager of the worker

Worker_Data/Management_Chain_Data/Worker_Supervisory_Management_Chain_Data/Management_Chain_Data[last()]/Manager_Reference/@Descriptor

JOBTITLE

Business title of the worker

Worker_Data/Employment_Data/Position_Data/Business_Title

JOBCODE

Job profile of the worker

Worker_Data/Employment_Data/Worker_Job_Data/Position_Data/Job_Profile_Summary_Data/Job_Profile_Reference/ID[@type='Job_Profile_ID']

EMPLOYEE_TYPE

Type of Employee

Worker_Data/Employment_Data/Position_Data/Worker_Type_Reference/ID[@type='Employee_Type_ID']

FIRST_NAME

Legal first name of the worker

Worker_Data/Personal_Data/Name_Data/Legal_Name_Data/Name_Detail_Data/First_Name

LAST_NAME

Legal last name of the worker

Worker_Data/Personal_Data/Name_Data/Legal_Name_Data/Name_Detail_Data/Last_Name

CLASS

Combination of Position, Time Type, and Employment Type

concat(Worker_Data/Employment_Data/Worker_Job_Data/Position_Data/Position_Title,Worker_Data/Employment_Data/Worker_Job_Data/Position_Data/Position_Time_Type_Reference/ID[@type='Position_Time_Type_ID'],Worker_Data/Employment_Data/Worker_Job_Data/Position_Data/Worker_Type_Reference/ID[@type='Employee_Type_ID'])

DEPARTMENT

Cost center

Concatenation of Worker/Cost, Center/Name, and Worker/Cost Center/Code

LOCATION

Location of the worker

Worker_Data/Employment_Data/Position_Data/Business_Site_Summary_Data/Name

TEAM

(Not applicable for Workday API version 30.1)

Team in the organization data of the worker

Worker_Data/Organization_Data/Worker_Organization_Data/Organization_Data[Organization_Type_Reference/ID

DIVISION

Sales channel in the organization data of the worker

Worker/Sales Channel/Name

COST_CENTER_HIERARCHY

Cost center hierarchy of the worker

Worker/Cost Center Hierarchy/Name

MANAGER_ID

Employee ID of the current manager of the worker

Worker/Manager/Employee ID

HIREDATE

Hire date of the worker

Worker_Data/Employment_Data/Worker_Status_Data/Hire_Date

TERMINATION_DATE

Termination date of the terminated employee

Worker_Data/Employment_Data/Worker_Status_Data/Termination_Date

FULLPARTTIME

Type of employment full time or part time

concat(Worker_Data/Employment_Data/Worker_Job_Data/Position_Data/Position_Title,Worker_Data/Employment_Data/Worker_Job_Data/Position_Data/Position_Time_Type_Reference/ID[@type='Position_Time_Type_ID'])

WORKER_NAME

Name of the worker

Worker_Data/Personal_Data/Name_Data/Preferred_Name_Data/Name_Detail_Data/@Formatted_Name

MIDDLE_NAME

Preferred Middle Name

Worker_Data/Personal_Data/Name_Data/Legal_Name_Data/Name_Detail_Data/Middle_Name

ON_LEAVE

Status of worker whether is he on leave

Worker_Data/Employment_Data/Worker_Status_Data/Leave_Status_Data[1]/@On_Leave

POSTAL_CODE

Postal Code of the city of a worker

Worker_Data/Personal_Data/Contact_Data/Address_Data[Usage_Data/Type_Data/Type_Reference/ID[@type='Communication_Usage_Type_ID'] ='WORK']/Postal_Code

COUNTRY

Country of a worker

Worker_Data/Personal_Data/Contact_Data/Address_Data[Usage_Data/Type_Data/Type_Reference/ID[@type='Communication_Usage_Type_ID']='WORK']/Country_Reference/ID[@type='ISO_3166-1_Alpha-3_Code']

CITY

City of a worker

Worker_Data/Personal_Data/Contact_Data/Address_Data[Usage_Data[@Public='true']/Type_Data[@Primary='true']/Type_Reference/ID[@type='Communication_Usage_Type_ID'] ='WORK']/Municipality

LEGAL_MIDDLE_NAME

Legal Middle Name of a worker

Worker/Legal Middle Name

FUTURE_DATE

Fetches the future date when the respective future action will be effective

 

FUTURE_ACTION

Fetches the future action that will be performed on the respective worker.

For example, Onboarding, Hire, Terminate

 

COST_CENTER

Represents the organization name whose type is COST_CENTER     

Worker_Data/Organization_Data/Worker_Organization_Data/Organization_Data[Organization_Type_Reference[ID[@type='Organization_Type_ID']='COST_CENTER']]/Organization_Name

WORK_MOBILE

Work phone of the worker with device type mobile

 

WORK_TELEPHONE

Work phone of the worker with device type telephone

 

HOME_MOBILE

Home phone of the worker with device type mobile

 

HOME_TELEPHONE

Home phone of the worker with device type telephone

 

PREFIX

The user's prefix. For example, Mr. or Mrs.

 

SUFFIX

The user's suffix. For exampe, Jr. or Sr.

 

PREFERRED_FIRST_NAME

Preferred first name of the user

 

LOCALE_ID

The ID for the user's locale

 

Time_Profile_ID

The ID of the user's timezone.

 

Optional Attributes

If you require the image attribute to be a String attribute type, add the attributes in the following table.

Note
Adding the image attribute to the schema may increase the time taken to fetch a response from the Workday source.

Attributes

Description

Source Data Element WD Object /Field Web Service Element File field

IMAGE_NAME

(type as String)

Image file name

Worker_Data/Photo_Data/File name

IMAGE

(type as String)

Image value as string

Worker_Data/Photo_Data/Image

EMAIL_ADDRESS_WORK

Email address of the worker

Worker_Data/Personal_Data/Contact_Data/Email_Address_Data[Usage_Data[@Public='true']/Type_Data[@Primary='true']/Type_Reference/ID[@type='Communication_Usage_Type_ID'] ='WORK']/Email_Address

EMAIL_ADDRESS_HOME

Home email address of the worker

Worker_Data/Personal_Data/Contact_Data/Email_Address_Data[Usage_Data[@Public='true']/Type_Data[@Primary='true']/Type_Reference/ID[@type='Communication_Usage_Type_ID'] ='HOME']/Email_Address

ADDRESS_HOME

Home address of the worker

Worker_Data/Personal_Data/Contact_Data/Address_Data[Usage_Data/Type_Data/Type_Reference/ID[@type='Communication_Usage_Type_ID'] ='HOME']/@Formatted_Address

ADDRESS_WORK

Work address of the worker

Worker_Data/Personal_Data/Contact_Data/Address_Data[Usage_Data/Type_Data/Type_Reference/ID[@type='Communication_Usage_Type_ID'] ='WORK']/@Formatted_Address

ADDITIONAL_PHONE_WORK

Additional business phone number of the worker

Worker_Data/Personal_Data/Contact_Data/Phone_Data[Usage_Data[@Public='true']/Type_Data[@Primary='false']/Type_Reference/ID[@type='Communication_Usage_Type_ID'] ='WORK']/@Formatted_Phone

ADDITIONAL_PHONE_HOME

Additional home phone number of a worker

Worker_Data/Personal_Data/Contact_Data/Phone_Data[Usage_Data[@Public='true']/Type_Data[@Primary='false']/Type_Reference/ID[@type='Communication_Usage_Type_ID'] ='HOME']/@Formatted_Phone

ADDITIONAL_EMAIL_ADDRESS_WORK

Additional Email address of the worker

Worker_Data/Personal_Data/Contact_Data/Email_Address_Data[Usage_Data[@Public='true']/Type_Data[@Primary='false']/Type_Reference/ID[@type='Communication_Usage_Type_ID'] ='WORK']/Email_Address

ADDITIONAL_EMAIL_ADDRESS_HOME

Additional Home email address of the worker

Worker_Data/Personal_Data/Contact_Data/Email_Address_Data[Usage_Data[@Public='true']/Type_Data[@Primary='false']/Type_Reference/ID[@type='Communication_Usage_Type_ID'] ='HOME']/Email_Address

ORGANIZATION_NAME

(Not applicable for Workday API version 30.1)

Represent organization name whose type is BUSINESS_UNIT

Worker_Data/Organization_Data/Worker_Organization_Data/Organization_Data[Organization_Type_Reference[@Descriptor ='Business Unit']]/Organization_Name

CONTRACT_END_DATE

Represent the contract end date of worker

Worker_Data/Employment_Data/Worker_Contract_Data/Contract_End_Date

ADDRESS_LINE_1

Represent business site's Address_line_1 of worker

Worker_Data/Employment_Data/Position_Data/Business_Site_Summary_Data/Address_Data/Address_Line_Data[@Type ='ADDRESS_LINE_1']

STATE

Represent business site's country region

Worker_Data/Employment_Data/Position_Data/Business_Site_Summary_Data/Address_Data/Country_Region_Reference/@Descriptor

LAST_DAY_OF_WORK

Represents the last day of work of the worker

Worker_Data/Employment_Data/Worker_Status_Data/Termination_Last_Day_of_Work

COST_CENTER_REFERENCE_ID

Represent reference ID of organization type COST CENTER

Worker_Data/Organization_Data/Worker_Organization_Data/Organization_Data[Organization_Type_Reference[@Descriptor ='Cost Center']]/Organization_Reference_ID

COMPANY_NAME

Represent organization name whose type is COMPANY

Worker_Data/Organization_Data/Worker_Organization_Data/Organization_Data[Organization_Type_Reference/ID [@type='Organization_Type_ID']='COMPANY']/Organization_Name

Note
For more information on Rescinded/Corrected Event for Hired and Terminated Workers, refer to Rescinded and Corrected User Records.

The Workday connector can aggregate fields in addition to the fields present in the default account schema. For more information, refer to XPATH to Support Additional Standard Attributes in Schema.