Tableau Connector for Workday

Build 20.0.7740

Positions

Contains each Position based on the Request References or Request Criteria. The data returned is the current information as of the dates in the response filter, and does not include all historical information about the position.

Columns

Name Type References Description
Position_RestrictionType_Position_Reference_WID String Contains a unique identifier for an instance of an object.
Position_RestrictionType_Position_Reference_Position_ID String Contains a unique identifier for an instance of an object.
Supervisory_Organization_Reference_WID String Contains a unique identifier for an instance of an object.
Supervisory_Organization_Reference_Organization_Reference_ID String Contains a unique identifier for an instance of an object.
Effective_Date Date Date this position is effective.
Position_ID String Unique identifier for the Position
Position_Definition_Job_Posting_Title String Job Posting Title for the Position.
Position_Definition_Academic_Tenure_Eligible Bool Value that represents if the position is eligible for academic tenure.
Position_Definition_Job_Description_Summary String Job Description Summary (plain text) for the Position.
Position_Status_Reference String The status history for the position. Doesn't respect the As of Effective Date filter. To filter by effective date, use the Get Worker Event History web service.
Available_For_Hire Bool Returns a true if this is able to be filled by a worker.
Available_for_Recruiting Bool Returns true if this is available for recruiting. If Enable Job Requisitons is turned off in the tenant, this is the same as Available for Hire.
Hiring_Freeze Bool Boolean attribute identifying whether a Hiring Freeze is currently in affect.
Work_Shift_Required Bool Returns true if the position is restricted to only one job profile and that job profile requires a work shift.
Available_for_Overlap Bool Returns true if the Position Restriction is available to be overlapped.
Earliest_Overlap_Date Date Returns the earliest date this Position Restriction can be filled with an overlapping worker. This will only have a value if the position restriction is available to be overlapped.
Critical_Job Bool Boolean attribute which is set to yes if the Position Restriction 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.
Availability_Date Date Date the opening is available.
Earliest_Hire_Date Date Earliest date that a worker can be hired/contracted into this opening.
Job_Family_Reference String Reference(s) to the job families that a worker being hired/contracted using this opening can use.
Location_Reference String Reference(s) to the location that a worker being hired/contracted using this opening can use.
Position_Restrictions_Worker_Type_Reference_WID String Contains a unique identifier for an instance of an object.
Position_Restrictions_Worker_Type_Reference_Worker_Type_ID String Contains a unique identifier for an instance of an object.
Time_Type_Reference_WID String Contains a unique identifier for an instance of an object.
Time_Type_Reference_Position_Time_Type_ID String Contains a unique identifier for an instance of an object.
Position_Worker_Type_Reference String Reference(s) to the position worker types that the position is restricted by (e.g., Regular, Contractor, Temporary).
Compensation_Package_Reference_WID String Contains a unique identifier for an instance of an object.
Compensation_Package_Reference_Compensation_Package_ID String Contains a unique identifier for an instance of an object.
Compensation_Grade_Reference_WID String Contains a unique identifier for an instance of an object.
Compensation_Grade_Reference_Compensation_Grade_ID String Contains a unique identifier for an instance of an object.
Compensation_Grade_Profile_Reference_WID String Contains a unique identifier for an instance of an object.
Compensation_Grade_Profile_Reference_Compensation_Grade_Profile_ID String Contains a unique identifier for an instance of an object.
Compensation_Step_Reference_WID String Contains a unique identifier for an instance of an object.
Compensation_Step_Reference_Compensation_Step_ID String Contains a unique identifier for an instance of an object.
Company_Assignments_Reference String Unique identifiers for the default company assignments for the Position.
Cost_Center_Assignments_Reference String Unique identifiers for the default cost center assignments for the Position.
Region_Assignments_Reference String Unique identifiers for the default region assignments for the Position.
Custom_Organization_Assignments_Reference String Unique identifiers for the default custom organization assignments for the Position.
Worker_Reference_WID String Contains a unique identifier for an instance of an object.
Worker_Reference_Contingent_Worker_ID String Contains a unique identifier for an instance of an object.
Worker_Reference_Employee_ID String Contains a unique identifier for an instance of an object.
Worker_For_Filled_Position_Position_Reference_WID String Contains a unique identifier for an instance of an object.
Worker_For_Filled_Position_Position_Reference_Position_ID String Contains a unique identifier for an instance of an object.
Job_Requisition_Reference_WID String Contains a unique identifier for an instance of an object.
Job_Requisition_Reference_Job_Requisition_ID String Contains a unique identifier for an instance of an object.
Job_Requisition_ID String The ID of the Job Requisition.
Job_Requisition_Status_Reference_WID String Contains a unique identifier for an instance of an object.
Job_Requisition_Status_Reference_Job_Requisition_Status_ID String Contains a unique identifier for an instance of an object.
Job_Requisition_Job_Posting_Title String The Job Posting Title of the Job Requisition.
Recruiting_Instruction_Reference_WID String Contains a unique identifier for an instance of an object.
Recruiting_Instruction_Reference_Recruiting_Instruction_ID String Contains a unique identifier for an instance of an object.
Do_Not_Send_To_Recruiting_System Bool Indicates the Job Requisition will be sent to an external recruiting system.
Name String The Name of the Recruiting Instruction
Job_Requisition_Academic_Tenure_Eligible Bool Indicates if the Job Requisition is for a position that is academic tenure eligible.
Number_of_Openings Decimal The number of positions made available by the job requisition. This number can only be greater than 1 for job requisitions created with the
Job_Requisition_Job_Description_Summary String The job description summary (plain text) for the job requisition.
Justification String The Justification for the Job Requisition.
Recruiting_Start_Date Date The Recruiting Start Date for the Job Requisition. Recruiting cannot be done for the position prior to this date.
Target_Hire_Date Date The Target Hire Date for the Job Requisition.
Target_End_Date Date The Target End Date for the Job Requisition is required for fixed term employees and contingent worker sub-types that are specified as requiring cost information.
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_Requisition_Worker_Type_Reference_WID String Contains a unique identifier for an instance of an object.
Job_Requisition_Worker_Type_Reference_Worker_Type_ID String Contains a unique identifier for an instance of an object.
Position_Worker_Type_Reference_WID String Contains a unique identifier for an instance of an object.
Position_Worker_Type_Reference_Contingent_Worker_Type_ID String Contains a unique identifier for an instance of an object.
Position_Worker_Type_Reference_Employee_Type_ID String Contains a unique identifier for an instance of an object.
Primary_Location_Reference_WID String Contains a unique identifier for an instance of an object.
Primary_Location_Reference_Location_ID String Contains a unique identifier for an instance of an object.
Additional_Locations_Reference String The Additional Location(s) for the Job Requisition.
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.
Scheduled_Weekly_Hours Decimal The Schedule Hours for the Job Requisition.
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.
Spotlight_Job Bool If Y, indicates that this is a highlighted job requisition.
Replacement_for_Worker_Reference_WID String Contains a unique identifier for an instance of an object.
Replacement_for_Worker_Reference_Contingent_Worker_ID String Contains a unique identifier for an instance of an object.
Replacement_for_Worker_Reference_Employee_ID String Contains a unique identifier for an instance of an object.
Closed Bool Returns true of the position is closed.

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