Service Directory > v32.1 > Resource_Management > Get_Project_Timesheets
 

Operation: Get_Project_Timesheets

This web service operation will get Project Timesheets for the specified criteria. A Project Timesheet is used to track time for an Activity such as the Project or Project Task for a Workday configured Project. Other Timesheet types include Payroll Total Hours and Payroll Time in Time Out.


@ - A parameter name with this symbol denotes an XML attribute within the document instead of an XML element.


Contents

 

Web Service

 

Request

 

Response

 

Element(s)

 

Request Element: Get_Project_Timesheets_Request

Get Project Timesheet Request
 
Parameter name Type/Value Cardinality Description Validations
@version string [0..1] Web Service version  
Request_References [Choice]   Project_Timesheet_Request_References  [0..1]  Encapsulates references to Project Timesheet   
Request_Criteria [Choice]   Project_Timesheet_Request_Criteria  [0..1]  This element contains request criteria that can be specified to find particular instances of Project Timesheet   
Response_Filter  Response_Filter  [0..1]  Parameters that let you filter the data returned in the response. You can filter returned data by dates and page attributes. 
Validation Description
Page Number cannot be zero.  Page number cannot be zero. 
 
top
 

Response Element: Get_Project_Timesheets_Response

Element containing Project Timesheet response elements including echoed request data
 
Parameter name Type/Value Cardinality Description Validations
@version string [0..1] Web Service version  
Request_References  Project_Timesheet_Request_References  [0..1]  References specified to instances of Project Timesheet   
Request_Criteria  Project_Timesheet_Request_Criteria  [0..1]  Project Timesheet Request Criteria   
Response_Filter  Response_Filter  [0..1]  Parameters that let you filter the data returned in the response. You can filter returned data by dates and page attributes. 
Validation Description
Page Number cannot be zero.  Page number cannot be zero. 
 
Response_Results  Response_Results  [0..1]  The "Response_Results" element contains summary information about the data that has been returned from your request including "Total_Results", "Total_Pages", and the current "Page" returned.   
Response_Data  Project_Timesheet_Response_Data  [0..1]  Project Timesheet Response Data   
top
 

Project_Timesheet_Request_References

part of: Get_Project_Timesheets_Request, Get_Project_Timesheets_Response
Encapsulates references to Project Timesheet
 
Parameter name Type/Value Cardinality Description Validations
Project_Timesheet_Reference  Project_TimesheetObject  [1..*]  References specified to instances of Project Timesheet   
top
 

Project_TimesheetObject

part of: Project_Timesheet_Request_References, Project_Timesheet
 
Parameter name Type/Value Cardinality Description Validations
@Descriptor  string  [1..1]  Display information used to describe an instance of an object. This 'optional' information is for outbound descriptive purposes only and is not processed on inbound Workday Web Services requests.   
ID  Project_TimesheetObjectID  [0..*]  Contains a unique identifier for an instance of an object.   
top
 

Project_TimesheetObjectID

part of: Project_TimesheetObject
Contains a unique identifier for an instance of an object.
 
Parameter name Type/Value Cardinality Description Validations
#text  string       
@type  WID, Project_Timesheet_ID  [1..1]  The unique identifier type. Each "ID" for an instance of an object contains a type and a value. A single instance of an object can have multiple "ID" but only a single "ID" per "type".   
top
 

Project_Timesheet_Request_Criteria

part of: Get_Project_Timesheets_Request, Get_Project_Timesheets_Response
Project Timesheet Request Criteria
 
Parameter name Type/Value Cardinality Description Validations
Supervisory_Organization_Reference  OrganizationObject  [1..1]  Reference to the Supervisory Organization to search for Timesheets in.   
Worker_Reference  WorkerObject  [0..*]  References to Workers to find timesheets for.   
Start_Date_On_or_After  date  [0..1]  Date to find Timesheets with a Period that starts on or after the date specified.   
Start_Date_On_or_Before  date  [0..1]  Date to find Timesheets with a Period that starts on or before the date specified.   
Document_Status_Reference  Document_StatusObject  [0..*]  References to status to find timesheets for.   
Period_Reference  PeriodObject  [0..1]  References to Periods to find timesheets for.   
Exclude_Worksheets  boolean  [0..1]  Boolean flag to indicate to exclude Timesheet Types of Project Worksheets. 1 = Exclude Worksheets, 0 = Include Worksheets   
top
 

OrganizationObject

part of: Project_Timesheet_Request_Criteria
 
Parameter name Type/Value Cardinality Description Validations
@Descriptor  string  [1..1]  Display information used to describe an instance of an object. This 'optional' information is for outbound descriptive purposes only and is not processed on inbound Workday Web Services requests.   
ID  OrganizationObjectID  [0..*]  Contains a unique identifier for an instance of an object.   
top
 

OrganizationObjectID

part of: OrganizationObject
Contains a unique identifier for an instance of an object.
 
Parameter name Type/Value Cardinality Description Validations
#text  string       
@type  WID, Company_Reference_ID, Cost_Center_Reference_ID, Custom_Organization_Reference_ID, Organization_Reference_ID, Region_Reference_ID  [1..1]  The unique identifier type. Each "ID" for an instance of an object contains a type and a value. A single instance of an object can have multiple "ID" but only a single "ID" per "type".   
top
 

WorkerObject

part of: Project_Timesheet_Request_Criteria, Project_Timesheet_Data
 
Parameter name Type/Value Cardinality Description Validations
@Descriptor  string  [1..1]  Display information used to describe an instance of an object. This 'optional' information is for outbound descriptive purposes only and is not processed on inbound Workday Web Services requests.   
ID  WorkerObjectID  [0..*]  Contains a unique identifier for an instance of an object.   
top
 

WorkerObjectID

part of: WorkerObject
Contains a unique identifier for an instance of an object.
 
Parameter name Type/Value Cardinality Description Validations
#text  string       
@type  WID, Contingent_Worker_ID, Employee_ID  [1..1]  The unique identifier type. Each "ID" for an instance of an object contains a type and a value. A single instance of an object can have multiple "ID" but only a single "ID" per "type".   
top
 

Document_StatusObject

part of: Project_Timesheet_Request_Criteria
 
Parameter name Type/Value Cardinality Description Validations
@Descriptor  string  [1..1]  Display information used to describe an instance of an object. This 'optional' information is for outbound descriptive purposes only and is not processed on inbound Workday Web Services requests.   
ID  Document_StatusObjectID  [0..*]  Contains a unique identifier for an instance of an object.   
top
 

Document_StatusObjectID

part of: Document_StatusObject
Contains a unique identifier for an instance of an object.
 
Parameter name Type/Value Cardinality Description Validations
#text  string       
@type  WID, Document_Status_ID  [1..1]  The unique identifier type. Each "ID" for an instance of an object contains a type and a value. A single instance of an object can have multiple "ID" but only a single "ID" per "type".   
top
 

PeriodObject

part of: Project_Timesheet_Request_Criteria, Project_Timesheet_Data
 
Parameter name Type/Value Cardinality Description Validations
@Descriptor  string  [1..1]  Display information used to describe an instance of an object. This 'optional' information is for outbound descriptive purposes only and is not processed on inbound Workday Web Services requests.   
ID  PeriodObjectID  [0..*]  Contains a unique identifier for an instance of an object.   
top
 

PeriodObjectID

part of: PeriodObject
Contains a unique identifier for an instance of an object.
 
Parameter name Type/Value Cardinality Description Validations
#text  string       
@type  WID, Period_ID  [1..1]  The unique identifier type. Each "ID" for an instance of an object contains a type and a value. A single instance of an object can have multiple "ID" but only a single "ID" per "type".   
top
 

Response_Filter

part of: Get_Project_Timesheets_Request, Get_Project_Timesheets_Response
Parameters that let you filter the data returned in the response. You can filter returned data by dates and page attributes.
 
Parameter name Type/Value Cardinality Description Validations
As_Of_Effective_Date  date  [0..1]  Indicates the date when application data, such as benefits and compensation, are deemed effective in the Workday system. (Also referred to as the "Effective Moment".) If not specified, this date defaults to TODAY.   
As_Of_Entry_DateTime  dateTime  [0..1]  Indicates the date and time that data was entered into the system. (This field is also referred to as the "Entry Moment".) If not specified, defaults to the CURRENT DATE/TIME.   
Page  decimal (12, 0) >0   [0..1]  Indicates the page of data to return in the response, and defaults to the first page (Page = 1). For responses that contain more than one page of data, use this parameter to retrieve the additional pages of data. For example, set Page = 2 to retrieve the second page of data. Note: If you set the page parameter, you must also specify the "As_Of_Entry_Date" to ensure that the result set remains the same between your requests.   
Count  decimal (3, 0) >0   [0..1]  Sets the number of objects to return within each response page (Min = 1, Max = 999, Default = 100 if not set). Any values you set must be between 1-999.   
Validation Description
Page Number cannot be zero.  Page number cannot be zero. 
top
 

Response_Results

part of: Get_Project_Timesheets_Response
The "Response_Results" element contains summary information about the data that has been returned from your request including "Total_Results", "Total_Pages", and the current "Page" returned.
 
Parameter name Type/Value Cardinality Description Validations
Total_Results  decimal (12, 0) >0   [0..1]  The total number of results that have been returned from your request.   
Total_Pages  decimal (12, 0) >0   [0..1]  The total number of pages that exist for your request. A page of data in WWS contains a maximum of 100 entries. So, if you have exactly 1,000 employees returned in a request, then you will have 10 pages of data that will need to be retrieved to build your complete dataset. Each page contains a maximum of 100 entries.   
Page_Results  decimal (12, 0) >0   [0..1]  Number of Results in current page.   
Page  decimal (12, 0) >0   [0..1]  The page of data that has been returned for the given request.   
top
 

Project_Timesheet_Response_Data

part of: Get_Project_Timesheets_Response
Project Timesheet Response Data
 
Parameter name Type/Value Cardinality Description Validations
Project_Timesheet  Project_Timesheet  [0..*]  Project Timesheet   
top
 

Project_Timesheet

part of: Project_Timesheet_Response_Data
Project Timesheet
 
Parameter name Type/Value Cardinality Description Validations
Project_Timesheet_Reference  Project_TimesheetObject  [0..1]  A reference to this timesheet object.   
Project_Timesheet_Data  Project_Timesheet_Data  [0..*]  Encapsulates all the data for a Project Timesheet 
Validation Description
Period for Project Timesheet must have Period Schedule usage type of Timesheet.   
Another Timesheet exists for this Period and Worker. Only one Project Timesheet per Period and Worker is permitted.   
Period can not be changed for an existing Timesheet   
Worker can not be changed for an existing Project Timesheet   
Please add at least one Timesheet Line   
Existing timesheet is a Project Timesheet, value for Timesheet Type is Project Worksheet must be 0 (false).   
Existing timesheet is a Project Worksheet, value for Timesheet Type is Project Worksheet must be 1 (true).   
The total hours from all default lines exceed 24 hours.   
 
top
 

Project_Timesheet_Data

part of: Project_Timesheet
This element encapsulates all the data associated with a single Project Timesheet.
 
Parameter name Type/Value Cardinality Description Validations
Project_Timesheet_ID  string  [0..1]  The unique ID for the Project Timesheet   
Locked_in_Workday  boolean  [0..1]  Set to True to disable editing and canceling the timesheet inside the Workday application. Timesheet can only be updated from the web service.   
Worker_Reference  WorkerObject  [0..1]  A reference to the Worker this timesheet is for.   
Period__Reference  PeriodObject  [0..1]  A reference to the Period this timesheet covers.   
Timesheet_Type_is_Project_Worksheet  boolean  [0..1]  Boolean flag to indicate if the Timesheet Type is a Project Worksheet. 1 = Project Worksheet, 0 = Project Timesheet   
Project_Timesheet_Line_Replacement_Data  Project_Timesheet_Line_Data  [0..*]  This element encapsulates data for a Project Timesheet Line, which contains multiple days' worth of timesheet information. 
Validation Description
Only one worktag for each type is allowed for each timesheet line.   
Only Time Codes not configured for use by earnings can be used for Project Timesheets   
Only one Line per Timesheet can have the same Time Code and Activity combination.   
Customer, Revenue Category, and Sales Item worktag types are not allowed when using a billable time code because these values come from the contract line that the project time will be billed by.   
Select a balancing worktag for Worktags of the following type: [type]   
 
Validation Description
Period for Project Timesheet must have Period Schedule usage type of Timesheet.   
Another Timesheet exists for this Period and Worker. Only one Project Timesheet per Period and Worker is permitted.   
Period can not be changed for an existing Timesheet   
Worker can not be changed for an existing Project Timesheet   
Please add at least one Timesheet Line   
Existing timesheet is a Project Timesheet, value for Timesheet Type is Project Worksheet must be 0 (false).   
Existing timesheet is a Project Worksheet, value for Timesheet Type is Project Worksheet must be 1 (true).   
The total hours from all default lines exceed 24 hours.   
top
 

Project_Timesheet_Line_Data

part of: Project_Timesheet_Data
This element encapsulates data for a Project Timesheet Line, which contains multiple days' worth of timesheet information.
 
Parameter name Type/Value Cardinality Description Validations
Time_Code_Reference  Time_Entry_CodeObject  [0..1]  A reference to the Time Code for this line.   
Activity_Reference  ActivityObject  [0..1]  Reference to an existing Activity for this line. Activity can be a Project or a Project Task. 
Validation Description
Please enter a valid Activity. Since the Time Code is billable, the Activity must be a project task directly assigned to the worker for this Timesheet.   
The project or project task is closed for time entry. If you need to enter time for this project or project task, contact the project manager or project administrator for [Task].   
Worker must be directly or indirectly assigned to an Activity (Project or Project Plan Task) in order to log time against that Activity.   
Either a shared or direct Resource Plan must exist for the Project in order to log time against the Project or Task.   
 
Worktag_Reference  Audited_Accounting_WorktagObject  [0..*]  Reference to existing worktags. Worktags are a way to mark tasks and business objects to make them easier to access and summarize. Each transaction can include one value for each worktag type and is subject to configurable validation when submitted for approval. 
Validation Description
[types] is not valid for a Timesheet. Please use worktags that are valid for a Timesheet.  The Worktags provided are not valid for this transaction 
 
Percent_Complete  decimal (7, 4) >0   [0..1]  Decimal value for Proposed Percent Complete of the Project Task selected. This value can be set via the Timesheet under certain condition and is then copied to the Project Task on Approval of the Timesheet. 
Validation Description
The value for Percent Complete Proposed can only be set where the Task is not 100% already on the Project and that Task is directly assigned to the worker.  The value for Percent Complete Proposed can only be set where the Task is not 100% already on the Project and that Task is directly assigned to the worker. 
Proposed Percent Complete Complete cannot be greater than 100%. Percent complete is in decimal format value can not be greater than 1.00.  Proposed Percent Complete Complete cannot be greater than 100%. Percent complete is in decimal format value can not be greater than 1.00. 
 
Memo  string  [0..1]  An optional memo for the Timesheet line.   
Worksheet_Allocation_Percent  decimal (6, 3)   [0..1]  Time allocation percent for a Project Worksheet Line. Indicates the percentage of time an employee spent on an activity for the specific time period. Applies to Project Worksheets only.   
Project_Timesheet_Day  Project_Timesheet_Day_Data  [0..*]  vThis element encapsulates data for a single Project Timesheet Day 
Validation Description
The date for the day on a Timesheet Line must be unique to other dates on the same Timesheet Line.   
 
Validation Description
Only one worktag for each type is allowed for each timesheet line.   
Only Time Codes not configured for use by earnings can be used for Project Timesheets   
Only one Line per Timesheet can have the same Time Code and Activity combination.   
Customer, Revenue Category, and Sales Item worktag types are not allowed when using a billable time code because these values come from the contract line that the project time will be billed by.   
Select a balancing worktag for Worktags of the following type: [type]   
top
 

Time_Entry_CodeObject

part of: Project_Timesheet_Line_Data
 
Parameter name Type/Value Cardinality Description Validations
@Descriptor  string  [1..1]  Display information used to describe an instance of an object. This 'optional' information is for outbound descriptive purposes only and is not processed on inbound Workday Web Services requests.   
ID  Time_Entry_CodeObjectID  [0..*]  Contains a unique identifier for an instance of an object.   
top
 

Time_Entry_CodeObjectID

part of: Time_Entry_CodeObject
Contains a unique identifier for an instance of an object.
 
Parameter name Type/Value Cardinality Description Validations
#text  string       
@type  WID, Time_Code_Reference_ID  [1..1]  The unique identifier type. Each "ID" for an instance of an object contains a type and a value. A single instance of an object can have multiple "ID" but only a single "ID" per "type".   
top
 

ActivityObject

part of: Project_Timesheet_Line_Data
 
Parameter name Type/Value Cardinality Description Validations
@Descriptor  string  [1..1]  Display information used to describe an instance of an object. This 'optional' information is for outbound descriptive purposes only and is not processed on inbound Workday Web Services requests.   
ID  ActivityObjectID  [0..*]  Contains a unique identifier for an instance of an object.   
top
 

ActivityObjectID

part of: ActivityObject
Contains a unique identifier for an instance of an object.
 
Parameter name Type/Value Cardinality Description Validations
#text  string       
@type  WID, Project_ID, Project_Plan_ID, Work_Assignment_ID, Work_Assignment_Version_ID, Work_Function_ID  [1..1]  The unique identifier type. Each "ID" for an instance of an object contains a type and a value. A single instance of an object can have multiple "ID" but only a single "ID" per "type".   
top
 

Audited_Accounting_WorktagObject

part of: Project_Timesheet_Line_Data
 
Parameter name Type/Value Cardinality Description Validations
@Descriptor  string  [1..1]  Display information used to describe an instance of an object. This 'optional' information is for outbound descriptive purposes only and is not processed on inbound Workday Web Services requests.   
ID  Audited_Accounting_WorktagObjectID  [0..*]  Contains a unique identifier for an instance of an object.   
top
 

Audited_Accounting_WorktagObjectID

part of: Audited_Accounting_WorktagObject
Contains a unique identifier for an instance of an object.
 
Parameter name Type/Value Cardinality Description Validations
#text  string       
@type  WID, Academic_Level_ID, Academic_Period_ID, Academic_Person_ID, Academic_Unit_ID, Ad_hoc_Payee_ID, Alternate_Supplier_Contract_ID, Applicant_ID, Asset_Adjustment_Reason_Reference_ID, Asset_Adjustment_Type_Reference_ID, Asset_Impairment_Reason_ID, Bank_Account_ID, Business_Asset_Cost_Adjustment_Reason_ID, Business_Unit_ID, Cash_Activity_Category_ID, Catalog_Item_ID, Company_Reference_ID, Compensation_Grade_ID, Contingent_Worker_ID, Contingent_Worker_Type_ID, Corporate_Credit_Card_Account_ID, Cost_Center_Reference_ID, Custom_Organization_Reference_ID, Custom_Worktag_06_ID, Custom_Worktag_07_ID, Custom_Worktag_08_ID, Custom_Worktag_09_ID, Custom_Worktag_1_ID, Custom_Worktag_10_ID, Custom_Worktag_11_ID, Custom_Worktag_12_ID, Custom_Worktag_13_ID, Custom_Worktag_14_ID, Custom_Worktag_15_ID, Custom_Worktag_2_ID, Custom_Worktag_3_ID, Custom_Worktag_4_ID, Custom_Worktag_5_ID, Customer_Category_ID, Customer_Contract_Alternate_Reference_ID, Customer_Contract_Reference_ID, Customer_ID, Customer_Reference_ID, Deduction_Recipient_ID, Donor_ID, Employee_ID, Employee_Type_ID, Ethnicity_ID, Expense_Item_ID, External_Committee_Member_ID, Financial_Institution_ID, Financial_Institution_Reference_ID, Fund_ID, Funding_Source_Name, Gender_Code, Gift_Reference_ID, Grant_ID, Internal_Service_Provider_ID, Internal_Service_Provider_Reference_ID, Investment_Pool_ID, Investment_Profile_ID, Investor_ID, Job_Category_ID, Job_Level_ID, Job_Profile_ID, Job_Requisition_ID, Loan_ID, Location_ID, Management_Level_ID, Object_Class_ID, Opportunity_Reference_ID, Organization_Reference_ID, Pay_Rate_Type_ID, Petty_Cash_Account_ID, Position_ID, Position_Time_Type_ID, Program_ID, Program_of_Study_ID, Project_ID, Project_Plan_ID, Proposal_Grant_ID, Prospect_ID, Prospect_Reference_ID, Purchase_Item_ID, Receivable_Writeoff_Reason_ID, Region_Reference_ID, Revenue_Category_ID, Run_Category_ID, Salary_Over_The_Cap_Type_ID, Sales_Item_ID, Spend_Category_ID, Sponsor_ID, Sponsor_Reference_ID, Student_Award_Item_ID, Student_Charge_Item_ID, Student_Course_ID, Student_Course_Section_ID, Student_ID, Student_Recruiting_Campaign_ID, Student_Recruiting_Event_ID, Student_Sponsor_Contract_ID, Student_Waiver_Item_ID, Supplier_Category_ID, Supplier_Contract_ID, Supplier_ID, Supplier_Reference_ID, Tax_Applicability_ID, Tax_Authority_ID, Tax_Authority_Reference_ID, Tax_Category_ID, Tax_Code_ID, Tax_Rate_ID, Tax_Recoverability_Object_ID, Third_Party_ID, Withholding_Order_Case_ID, Withholding_Tax_Code_ID, Withholding_Tax_Rate_ID, Work_Function_ID, Work_Shift_ID  [1..1]  The unique identifier type. Each "ID" for an instance of an object contains a type and a value. A single instance of an object can have multiple "ID" but only a single "ID" per "type".   
top
 

Project_Timesheet_Day_Data

part of: Project_Timesheet_Line_Data
vThis element encapsulates data for a single Project Timesheet Day
 
Parameter name Type/Value Cardinality Description Validations
Date  date  [0..1]  The date this day contains hours for. 
Validation Description
The date for the day on the timesheet ([timesheet day date]) must be within the date range of the Period selected: [period start] to [period end]   
Select a valid activity for the date. The hours you entered are outside the date range for your selected activity.   
 
Hours  decimal (14, 2)   [0..1]  The total hours worked on this day.   
Validation Description
The date for the day on a Timesheet Line must be unique to other dates on the same Timesheet Line.   
top
 

Project_TimesheetReferenceEnumeration

part of: Project_TimesheetObjectID
Base Type
string
top
 

OrganizationReferenceEnumeration

part of: OrganizationObjectID
Base Type
string
top
 

WorkerReferenceEnumeration

part of: WorkerObjectID
Base Type
string
top
 

Document_StatusReferenceEnumeration

part of: Document_StatusObjectID
Base Type
string
top
 

PeriodReferenceEnumeration

part of: PeriodObjectID
Base Type
string
top
 

Time_Entry_CodeReferenceEnumeration

part of: Time_Entry_CodeObjectID
Base Type
string
top
 

ActivityReferenceEnumeration

part of: ActivityObjectID
Base Type
string
top
 

Audited_Accounting_WorktagReferenceEnumeration

part of: Audited_Accounting_WorktagObjectID
Base Type
string
top