Resource

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

Field

Description

AutoComputeActuals

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.

CalculateCostFromUnits

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

CalendarName

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

CalendarObjectId

The unique ID of the calendar assigned to the resource.

CreateDate

The date this resource was created.

CreateUser

The name of the user that created this resource.

CurrencyId

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

CurrencyName

The name of the currency associated with this resource.

CurrencyObjectId

The unique ID of the currency associated with this resource.

DefaultUnitsPerTime

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

EffectiveDate

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

EmailAddress

The e-mail address for the resource.

EmployeeId

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

GUID

The globally unique ID generated by the system.

Id

The short code that uniquely identifies the resource.

IntegratedType

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.

IsActive

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.

IsOverTimeAllowed

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

LastUpdateDate

The date this resource was last updated.

LastUpdateUser

The name of the user that last updated this resource.

LocationName

The name of the location assigned to the resource.

LocationObjectId

The unique ID of the location assigned to the resource.

MaxUnitsPerTime

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

Name

The name of the resource.

ObjectId

The unique ID generated by the system.

OfficePhone

The office phone number for the resource.

OtherPhone

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

OvertimeFactor

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

ParentObjectId

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

PricePerUnit

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

PrimaryRoleId

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

PrimaryRoleName

The name of the primary role for this resource.

PrimaryRoleObjectId

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

ResourceNotes

The notes about the resource.

ResourceType

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.

SequenceNumber

The sequence number for sorting.

ShiftObjectId

The unique ID of the shift associated with the resource.

TimesheetApprovalManager

The resource manager assigned to approve timesheets for the resource.

TimesheetApprovalManagerObjectId

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

Title

The title of the resource.

UnitOfMeasureAbbreviation

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

UseTimesheets

The option that determines whether the resource uses timesheets.

UserName

The user's login name.

UserObjectId

The unique ID of the associated user.

Related Topics

P6 Business Objects

Activity

ActivityCode

ActivityCodeType

ActivityExpense

ActivityRisk

BaselineType

Calendar

CBS

CBSDurationSummary

CBSExpenseSpread

CBSResourceSpread

CostAccount

Currency

EPS

ExpenseCategory

FinancialPeriod

Location

NotebookTopic

Project

ProjectCode

ProjectCodeType

ProjectResource

Relationship

ResourceAssignment

ResourceCode

ResourceCodeType

ResourceRate

Risk

RiskImpact

RiskMatrix

RiskMatrixScore

RiskMatrixThreshold

RiskResponseAction

RiskResponseActionImpact

RiskResponsePlan

RiskThreshold

RiskThresholdLevel

Role

RoleRate

UDFType

WBS

WBSCategory

WBSExpenseSpread

WBSResourceSpread

WBSSpread



Legal Notices
Copyright © 2013, 2015, Oracle and/or its affiliates. All rights reserved.

Last Published Monday, March 30, 2015