Resource

Description: Resources include labor, nonlabor, and materials that are used for activities across all projects.

Field

Type

Description

Read-Only

AutoComputeActuals

Boolean

The option that determines whether the activity actual and remaining units, and start and finish dates for the resource are calculated automatically using the planned dates, planned units, and the activity's schedule percent complete.

No

CalculateCostFromUnits

Boolean

The option that determines whether any new assignments for this resource will have its costs recalculated whenever any quantity changes occur.

No

CalendarName

String

The name of the calendar that is assigned to the resource.

Yes

CalendarObjectId

ForeignKey

The unique ID of the calendar assigned to the resource.

No

CreateDate

DateTime

The date this resource was created.

Yes

CreateUser

String

The name of the user that created this resource.

Yes

CurrencyId

String

The unique currency abbreviation for the currency associated with this resource.

Yes

CurrencyName

String

The name of the currency associated with this resource.

Yes

CurrencyObjectId

Int

The unique ID of the currency associated with this resource.

No

DefaultUnitsPerTime

Double

The default units/time setting, which determines the value of the remaining units/time and planned units/time when a resource assignment is added.

No

EffectiveDate

DateTime

The earliest day when the resource becomes overallocated. This date is calculated during the summarization.

Yes

EmailAddress

String

The e-mail address for the resource.

No

EmployeeId

String

The resource identifier within the organization, typically the employee number or social security number.

No

GUID

String

The globally unique ID generated by the system.

No

Id

String

The short code that uniquely identifies the resource.

No

IntegratedType

Enum

The indicator that determines whether the resource is integrated with an Enterprise Resource Planning (ERP) system. 'Fusion' indicates the resource is integrated with Oracle Fusion. 'ERP' indicates the resource is integrated with another ERP system.

No

IsActive

Boolean

The option that determines whether the resource is currently active. Non-active resources may be resources that have left the organization but not deleted from the system since they may have actual hours.

No

IsOverTimeAllowed

Boolean

The option that determines whether the resource is allowed to log overtime hours.

No

LastUpdateDate

DateTime

The date this resource was last updated.

Yes

LastUpdateUser

String

The name of the user that last updated this resource.

Yes

Latitude

Double

The latitude of the location.

Yes

LocationName

String

The name of the location assigned to the resource.

Yes

LocationObjectId

Int

The unique ID of the location assigned to the resource.

No

Longitude

Double

The longitude of the location.

Yes

MaxUnitsPerTime

Double

The maximum work units per time this resource can perform on all their assigned activities.

Yes

Name

String

The name of the resource.

No

ObjectId

Int

The unique ID generated by the system.

No

OfficePhone

String

The office phone number for the resource.

No

OtherPhone

String

The other phone numbers for the resource - pager, home phone, cell phone, etc.

No

OvertimeFactor

Double

The overtime factor used to compute the overtime price for the resource.

No

ParentObjectId

ForeignKey

The unique ID of the parent resource of this resource in the hierarchy.

No

PricePerUnit

Double

The planned price per unit for the project expense. This number is multiplied by the planned number of units to compute the planned cost.

Yes

PrimaryRoleId

String

The short code that uniquely identifies the primary role for this resource.

Yes

PrimaryRoleName

String

The name of the primary role for this resource.

Yes

PrimaryRoleObjectId

ForeignKey

The unique ID of the role that is assigned as the resource's primary role.

No

ResourceNotes

String

The notes about the resource.

No

ResourceType

String

The resource type: Labor resource performs labor and is measured in units of time, Nonlabor resource does not perform labor and is measured in units of time, Material resource has a unit of measure other than time.

No

SequenceNumber

Int

The sequence number for sorting.

No

ShiftObjectId

Int

The unique ID of the shift associated with the resource.

No

TimesheetApprovalManager

String

The resource manager assigned to approve timesheets for the resource.

Yes

TimesheetApprovalManagerObjectId

Int

The unique ID of the resource manager assigned to approve timesheets for the resource.

No

Title

String

The title of the resource.

No

UnitOfMeasureAbbreviation

Int

The unique ID of the unit of measure this material resource uses.

Yes

UserName

String

The user's login name.

Yes

UserObjectId

Int

The unique ID of the associated user.

No

UseTimesheets

Boolean

The option that determines whether the resource uses timesheets.

Yes



Legal Notices | Your Privacy Rights
Copyright © 2013, 2022

Last Published Monday, January 31, 2022