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 | The report format. Corresponds to the Show Actual Effort breakdown at day level filter on the report. Valid values include:
|
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. |
Legal Notices
Copyright © 2000, 2018,
Oracle and/or its affiliates. All rights reserved.
Last Published Thursday, May 03, 2018