Output Parameters

The results of the GetActivityAssignments function are provided in JSON data format. The following table details the name/value pairs.

Name

Data Type

Description

global_properties

Object

This object lists the global settings for your EnterpriseTrack instance.

See "global_properties Object" for details.

application_data

Object

This object lists your search criteria and provides the results.

See "application_data" for details.

application_data

et_transaction_id

String

Provides the unique EnterpriseTrack transaction ID that is stored in the audit tables.

result_code

String

Provides the result code for the completion status of the function.

result_reason

String

If the function is successful, NULL is returned.

Otherwise, the reason for the error is returned.

activity_
descriptor_list

Object

This object contains the lists of activities corresponding to the search criteria you specified.

See "activity_descriptor_list" for details.

activity_descriptor_list

resource_descriptor

Object

This object specifies the resource.

See "resource_descriptor" for details.

total_assignments

Integer

Provides the total number of assignments for the specified resource.

rows_returned

Integer

Specifies the number of activities actually returned.

This could be different from the number of total assignments due to the restrictions imposed by the max_rows value you specified in the input parameters.

activity_descriptor

Array of Objects

These objects contain the details of an activity.

See "activity_descriptor" for details.

project_descriptor

Object

This object provides the details of the project.

See "project_descriptor" for details.

resource_descriptor

resource_id

String

Specifies the resource ID.

resource_login_id

String

Specifies the login ID.

resource_email

String

Specifies the e-mail address.

resource_last_
name

String

Specifies the last name.

resource_first_
name

String

Specifies the first name.

activity_descriptor

activity_id

String

Provides the ID for the activity.

activity_name

String

Provides the name of the activity.

activity_desc

String

Provides the comments associated with the activity.

activity_type

String

Provides the type of the activity.

activity_
planned_start_
date

Date

Provides the planned start date of the activity.

In some cases, this value may be NULL.

activity_
planned_end_date

Date

Provides the planned end date of the activity.

In some cases, this value may be NULL.

activity_
actual_start_date

Date

Provides the actual start date of the activity.

activity_
actual_end_date

Date

Provides the actual end date of the activity.

activity_actual_
efforts

Number

Provides the actual effort for the activity.

activity_
remaining_efforts

Number

Provides the computed remaining effort for the activity.

activity_planned_
efforts

Number

Provides the planned effort for the activity.

activity_
percent_completion

Number

Provides the percentage completion of the activity.

activity_owner_
info

String

Specifies the name(s) of the activity owner.

The format is last name, comma, a space, first name, a space, and then the role enclosed in parentheses.

Multiple values should be separated by semicolons.

For example: John, Smith (Project Manager); John, Jones (Network Admin).

activity_
baseline_start_date

Date

Provides the baseline start date for the activity.

activity_
baseline_end_date

Date

Provides the baseline end date for the activity.

activity_planned_
effort_type

String

Provides the planned effort type for the activity.

activity_actual_
effort_type

String

Provides the actual effort type for the activity.

status_descriptor

Object

This object specifies the status of the activity.

See "status_descriptor" for details.

role_descriptor

Object

This object provides details about the role.

See "role_descriptor" for details.

activity_external

String

Indicates whether or not the activity is tracked outside of the EnterpriseTrack.

Expected values are:

  • YES
  • NO

activity_
external_id

String

Provides the external ID if the activity is tracked outside of the EnterpriseTrack.

This value is typically NULL when the value for activity_assignment_external is NO.

project_descriptor

Object

This object provides the project details.

See "project_descriptor" for details.

status_descriptor

status_id

String

Provides the ID of the status.

status_desc

String

Provides the description of the status.

role_descriptor

role_id

String

Provides the ID of the role.

role_desc

String

Provides the description of the role.

project_descriptor

project_id

Integer

Provides the ID for the project.

project_name

String

Provides the name for the project.

project_manager

String

Provides the name of the manager of the project.

project_status

String

Provides the status of the project.

project_program

String

Provides the names of the programs associated with the project.

Related Topics

GetActivityAssignments Function

Output Example

Invocation Parameters

Input Parameters



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

Last Published Thursday, May 03, 2018