Input Parameters

The input parameters described in the following table provide the search criteria (filter data) needed to identify the data for the Timesheet Detail report. This information should be provided in JSON formatted data specified by <input_params>. Unless otherwise specified, all values are not case sensitive.

Name

Data Type

Value Required?

Placeholder or Constant

Description

report_format

String

Yes

Not
applicable

The report format. Corresponds to the Show Actual Effort breakdown at day level filter on the report. Valid values include:

  • Summary
  • Daily (default)

timesheet_from_date

Date

Yes

 

The start date of the Timesheet Detail report. Corresponds to the Timesheet From Date filter on the report.

timesheet_to_date

Date

Yes

 

The end date of the Timesheet Detail report. Corresponds to the Timesheet To Date filter on the report.

report_project_time

String

 

 

Corresponds to the Show Project Overhead Categories filter on the report. Defaults to Yes.

report_non_project_and_non_working_time

String

 

 

Corresponds to the Show Non-project Overhead Categories filter on the report. Defaults to Yes.

report_activity_time

String

 

 

Corresponds to the Show Activity Details filter on the report. Defaults to Yes

report_zero_effort_rows

String

 

 

Corresponds to the Suppress rows where Actual Total Effort is zero filter on the report. Defaults to No.

report_cost

String

 

 

Corresponds to the Show Cost filter on the report. Defaults to Yes.

report_disabled_categories

String

 

 

Corresponds to the Include disabled Time Reporting Categories filter on the report. Defaults to Yes.

timesheet_status

String

 

 

Corresponds to the Timesheet Status filter on the report. Specify as comma-separated values.

timesheet_submitter

Object

Yes

 

Corresponds to the Submitter filter on the report. Enter the first name or the last name. The first matching resource will be used. Only one submitter can be specified on the report.

timesheet_approver

Object

Yes

 

Corresponds to the Approver filter on the report. Enter the first name or the last name. The first matching resource will be used. Only one approver can be specified on the report.

pcs

String

 

 

Corresponds to the Initiative filter on the report. Specify comma-separated values.

Project_id

String

Yes

 

Corresponds to the Project ID filter on the report.

project_name

String

 

 

Corresponds to the Project Name filter on the report.

project_keyword

String

 

 

Corresponds to the Keyword filter on the report. Specify comma-separated values.

project_status

String

 

 

Corresponds to the Project Status filter on the report. Specify comma-separated values.

project_org_descriptor->division

String

 

 

Corresponds to the Division filter on the report. Specify comma-separated values.

project_org_descriptor->business_unit

String

 

 

Corresponds to the Business Unit filter on the report. Specify comma-separated values.

project_org_descriptor->sub_business_unit

String

 

 

Corresponds to the Sub unit filter on the report. Specify comma-separated values.

project_org_descriptor->location

String

 

 

Corresponds to the Location filter on the report. Specify comma-separated values.

project_org_descriptor->region

String

 

 

Corresponds to the Region filter on the report. Specify comma-separated values.

resource_login_id

String

 

 

Corresponds to the Login ID filter on the report.

resource_email

String

 

 

Corresponds to the Email filter on the report.

resource_last_name

String

 

 

Corresponds to the Last Name filter on the report.

resource_title

String

 

 

Corresponds to the Access Profile filter on the report. Specify multiple Access Profiles as comma-separated values.

resource_area_of_expertise

String

 

 

Corresponds to the Area of Expertise filter on the report.

resource_manager

Object

 

 

Corresponds to the Manager filter on the report. Enter the first name or the last name. The first matching resource will be used. Multiple managers can be specified.

program

String

 

 

Corresponds to the Program filter on the report. Specify multiple programs as comma-separated values.

resource_org_descriptor->division

String

 

 

Corresponds to the Division filter on the report. Specify multiple divisions as comma-separated values.

resource_org_descriptor->business_unit

String

 

 

Corresponds to the Business Unit filter on the report. Specify multiple business units as comma-separated values.

resource_org_descriptor->sub_business_unit

String

 

 

Corresponds to the Sub unit filter on the report. Specify multiple sub units as comma-separated values.

resource_org_descriptor->location

String

 

 

Corresponds to the Location filter on the report. Specify multiple locations as comma-separated values.

resource_org_descriptor->region

String

 

 

Corresponds to the Region filter on the report. Specify multiple regions as comma-separated values.

labor_expense_type

String

 

 

Corresponds to the Labor Expense Type filter on the report. Specify multiple labor expense types as comma-separated values.

labor_expense_category

String

 

 

Corresponds to the Labor Expense Category filter on the report. Specify multiple labor expense categories as comma-separated values.

report_currency

 

Yes

 

Corresponds to the Reporting Currency filter on the report. Defaults to the system currency unit.

output_custom_field_list

 

 

 

Corresponds to the Output Custom Fields filter on the report. Specify a list of custom fields to be included in the report output. Multiple custom fields can be specified as comma-separated values.

Related Topics

getTimesheetData Function

Invocation Syntax

Invocation Parameters

Input Example in JSON Format

Output

Output example



Legal Notices
Copyright © 2000, 2018, Oracle and/or its affiliates. All rights reserved.

Last Published Thursday, May 03, 2018