Tableau Connector for Workday

Build 20.0.7740

Workers_Worker_Job_Data

Contains the Position-level data for a Worker. The primary position is always the first element.

Columns

Name Type References Description
Worker_Worker_Reference_WID String

Workers.Worker_Reference_WID

The unique identifier type. Each
Position_Reference_WID String Contains a unique identifier for an instance of an object.
Position_Reference_Position_ID String Contains a unique identifier for an instance of an object.
Headcount_Reference_WID String Contains a unique identifier for an instance of an object.
Headcount_Reference_Headcount_Restrictions_ID String Contains a unique identifier for an instance of an object.
Position_ID String Text attribute identifying Position ID.
Position_Title String Text attribute identifying Position Title.
Business_Title String Business title for the position.
Start_Date Date Date the Worker first started work in this Position. Will be the same value as the Hire Date in the Worker Status Section for the Primary Position.
End_Employment_Date Date Expected end of employment for this position. Will be the same value as the End Employment Date in the Worker Status Section for the Primary Position.
End_Employment_Reason_Reference String Termination/End Additional Job Reason
Worker_Type_Reference_WID String Contains a unique identifier for an instance of an object.
Worker_Type_Reference_Contingent_Worker_Type_ID String Contains a unique identifier for an instance of an object.
Worker_Type_Reference_Employee_Type_ID String Contains a unique identifier for an instance of an object.
Position_Time_Type_Reference_WID String Contains a unique identifier for an instance of an object.
Position_Time_Type_Reference_Position_Time_Type_ID String Contains a unique identifier for an instance of an object.
Position_Job_Exempt Bool Boolean attribute identifying whether Position is Exempt.
Position_Scheduled_Weekly_Hours Decimal Scheduled Weekly Hours for Position.
Default_Weekly_Hours Decimal Standard Weekly Hours for Position.
Working_Time_Frequency_Reference_WID String Contains a unique identifier for an instance of an object.
Working_Time_Frequency_Reference_Frequency_ID String Contains a unique identifier for an instance of an object.
Working_Time_Unit_Reference_WID String Contains a unique identifier for an instance of an object.
Working_Time_Unit_Reference_Working_Time_Unit_Type_ID String Contains a unique identifier for an instance of an object.
Working_Time_Value Decimal The numeric value of the Working Time Unit. Enable Working Time in the Maintain Localization Settings task.
Full_Time_Equivalent_Percentage Decimal Full Time Equivalent Percentage for Position.
Specify_Paid_FTE Bool True if Paid FTE Percentage is specified on the position.
Paid_FTE Decimal The paid full time equivalent percentage for the position, entered as a decimal value. This overrides the calculated full time equivalent.
Specify_Working_FTE Bool True if Working FTE Percentage is specified on the position.
Working_FTE Decimal The working full time equivalent percentage for the position, entered as a decimal value. This overrides the calculated full time equivalent.
Exclude_from_Headcount Bool If Y, the position will be excluded from headcount reporting.
Position_Pay_Rate_Type_Reference_WID String Contains a unique identifier for an instance of an object.
Position_Pay_Rate_Type_Reference_Pay_Rate_Type_ID String Contains a unique identifier for an instance of an object.
Job_Classification_Summary_Data String Contains the job classifications from the job profile for the position and the additional job classifications specified for the position.
Company_Insider_Reference String Reference to a company insider type.
Work_Shift_Reference_WID String Contains a unique identifier for an instance of an object.
Work_Shift_Reference_Work_Shift_ID String Contains a unique identifier for an instance of an object.
Work_Hours_Profiles_Reference_WID String Contains a unique identifier for an instance of an object.
Work_Hours_Profiles_Reference_Work_Hours_Profile_ID String Contains a unique identifier for an instance of an object.
Federal_Withholding_FEIN String The employee's company Federal Employer Identification Number.
Worker_Compensation_Code_Data String The worker's compensation code for this position - based on the location and job profile.
Position_Payroll_Reporting_Code_Data String Contains each payroll reporting code for the position.
Job_Profile_Reference_WID String Contains a unique identifier for an instance of an object.
Job_Profile_Reference_Job_Profile_ID String Contains a unique identifier for an instance of an object.
Job_Profile_Summary_Job_Exempt Bool A boolean attribute that returns true if the job profile is exempt for this position. Exempt job profiles are typically for positions that are salaried and not eligible for overtime pay.
Management_Level_Reference_WID String Contains a unique identifier for an instance of an object.
Management_Level_Reference_Management_Level_ID String Contains a unique identifier for an instance of an object.
Job_Category_Reference_WID String Contains a unique identifier for an instance of an object.
Job_Category_Reference_Job_Category_ID String Contains a unique identifier for an instance of an object.
Job_Family_Reference String A unique identifier for the job family.
Job_Profile_Name String The name of the job profile.
Work_Shift_Required Bool A boolean attribute that returns true if a work shift is required on the position where this job profile is used.
Critical_Job Bool Boolean attribute indicating whether the job profile is considered a critical job.
Difficulty_to_Fill_Reference_WID String Contains a unique identifier for an instance of an object.
Difficulty_to_Fill_Reference_Difficulty_to_Fill_Code String Contains a unique identifier for an instance of an object.
Location_Reference_WID String Contains a unique identifier for an instance of an object.
Location_Reference_Location_ID String Contains a unique identifier for an instance of an object.
Name String The name of the location.
Location_Type_Reference String The type(s) of a location.
Local_Reference_WID String Contains a unique identifier for an instance of an object.
Local_Reference_Locale_ID String Contains a unique identifier for an instance of an object.
Display_Language_Reference_WID String Contains a unique identifier for an instance of an object.
Display_Language_Reference_User_Language_ID String Contains a unique identifier for an instance of an object.
Time_Profile_Reference_WID String Contains a unique identifier for an instance of an object.
Time_Profile_Reference_Time_Profile_ID String Contains a unique identifier for an instance of an object.
Business_Site_Summary_Scheduled_Weekly_Hours Decimal The scheduled weekly hours from the location's time profile.
Address_Data String Address information
Effective_Date Date Effective Date for Payroll Interface Processing.
Payroll_Interface_Processing_Pay_Rate_Type_Reference_WID String Contains a unique identifier for an instance of an object.
Payroll_Interface_Processing_Pay_Rate_Type_Reference_Pay_Rate_Type_ID String Contains a unique identifier for an instance of an object.
Frequency_Reference_WID String Contains a unique identifier for an instance of an object.
Frequency_Reference_Frequency_ID String Contains a unique identifier for an instance of an object.
Pay_Group_Reference_WID String Contains a unique identifier for an instance of an object.
Pay_Group_Reference_Ext_Pay_Group_ID String Contains a unique identifier for an instance of an object.
Pay_Group_Reference_External_Pay_Group_ID String Contains a unique identifier for an instance of an object.
Payroll_Entity_Reference_WID String Contains a unique identifier for an instance of an object.
Payroll_Entity_Reference_External_Payroll_Entity_ID String Contains a unique identifier for an instance of an object.
External_Employee_Type_Reference_WID String Contains a unique identifier for an instance of an object.
External_Employee_Type_Reference_EmployeeType String Contains a unique identifier for an instance of an object.
External_Employee_Type_Reference_External_Payroll_Employee_Type_ID String Contains a unique identifier for an instance of an object.
Payroll_File_Number String The external payroll file number for the position.
Regular_Paid_Equivalent_Hours Decimal Numeric value for number of equivalent regular paid hours for the work hours profile.
Worker_Hours_Profile_Classification String The Worker Hours Profile Classification.
International_Assignment_Type_Reference_WID String Contains a unique identifier for an instance of an object.
International_Assignment_Type_Reference_International_Assignment_Type_ID String Contains a unique identifier for an instance of an object.
Start_International_Assignment_Reason_Reference_WID String Contains a unique identifier for an instance of an object.
Start_International_Assignment_Reason_Reference_Benefits_Event_Subcategory_ID String Contains a unique identifier for an instance of an object.
Start_International_Assignment_Reason_Reference_Change_Job_Subcategory_ID String Contains a unique identifier for an instance of an object.
Start_International_Assignment_Reason_Reference_End_Additional_Job_Subcategory_ID String Contains a unique identifier for an instance of an object.
Start_International_Assignment_Reason_Reference_Event_Classification_Subcategory_ID String Contains a unique identifier for an instance of an object.
Start_International_Assignment_Reason_Reference_General_Event_Subcategory_ID String Contains a unique identifier for an instance of an object.
Start_International_Assignment_Reason_Reference_Leave_of_Absence_Type_ID String Contains a unique identifier for an instance of an object.
Start_International_Assignment_Reason_Reference_Termination_Subcategory_ID String Contains a unique identifier for an instance of an object.
Start_International_Assignment_Reason_Reference_Undo_Move_Subcategory_ID String Contains a unique identifier for an instance of an object.
Expected_Assignment_End_Date Date The End Date for the International Assignment. If empty, Workday will use the existing date. This field is informational only. The value is effective immediately on update.
Host_Country_Reference_WID String Contains a unique identifier for an instance of an object.
Host_Country_Reference_ISO_3166_1_Alpha_2_Code String Contains a unique identifier for an instance of an object.
Host_Country_Reference_ISO_3166_1_Alpha_3_Code String Contains a unique identifier for an instance of an object.
Host_Country_Reference_ISO_3166_1_Numeric_3_Code String Contains a unique identifier for an instance of an object.
Home_Country_Reference_WID String Contains a unique identifier for an instance of an object.
Home_Country_Reference_ISO_3166_1_Alpha_2_Code String Contains a unique identifier for an instance of an object.
Home_Country_Reference_ISO_3166_1_Alpha_3_Code String Contains a unique identifier for an instance of an object.
Home_Country_Reference_ISO_3166_1_Numeric_3_Code String Contains a unique identifier for an instance of an object.
Work_Space_Reference_WID String Contains a unique identifier for an instance of an object.
Work_Space_Reference_Location_ID String Contains a unique identifier for an instance of an object.
Annual_Work_Period_Work_Percent_of_Year Decimal Work period percent of year from the annual work period assigned to position.
Annual_Work_Period_Start_Date Date Start date for annual work period assigned to the position based on the effective moment from the request.
Annual_Work_Period_End_Date Date End date for annual work period assigned to the position based on the effective moment from the request.
Disbursement_Plan_Period_Start_Date Date Start date for disbursement plan period assigned to the position based on the effective moment from the request.
Disbursement_Plan_Period_End_Date Date End date for disbursement plan period assigned to the position based on the effective moment from the request.
End_Date Date The effective date of the end employment business process
Pay_Through_Date Date The pay through date for the end of employment
Collective_Agreement_Summary_Data String Encapsulating element containing all Collective Agreement data. Including Corrected data.
Employee_Probation_Period_Detail_Data String The Worker's Probation Period Data.
Manager_as_of_last_detected_manager_change_Reference String Return the worker's new manager(s) during the most recent manager change event detected by manager compare background process. The background process may detect manager changes at a later time then when the manager change actually occurred. This field only applies for the primary job of the worker.
Position_Organization_Data String Contains the organization reference and details about an organization.
Pay_Group_Assignment_Correct_or_Rescind_Data String Provides additional information on Pay Group Assignment corrections or rescinds. This element only reports Pay Group Assignment Rescind events.
Position_Supervisory_Management_Chain_Management_Chain_Data String Contains the organization reference and details about an organization.
Position_Matrix_Management_Chain_Management_Chain_Data String Contains the organization reference and details about an organization.

Copyright (c) 2021 CData Software, Inc. - All rights reserved.
Build 20.0.7740