Field
|
Type
|
Read Only
|
Filterable Orderable
|
Description
|
AutoComputeActuals
|
boolean
|
|
X
|
The flag that identifies whether the activity actual and remaining units, start dates and finish dates for the resource are computed automatically using the planned dates, planned units and the activity's schedule percent complete. If this option is selected, the actual/remaining units and actual dates are automatically updated when project actuals are applied. This assumes that all work by the resource proceeds according to plan.
|
CalculateCostFromUnits
|
boolean
|
|
X
|
the option to indicate that any new assignments for this resource will have its costs recalculated whenever any quantity changes occur.
|
CalendarName
|
string restricted to maxLength(60)
|
X
|
X
|
The name of the calendar.
|
CalendarObjectId
|
int
|
|
X
|
The unique ID of the calendar assigned to the resource. Resource calendars can be assigned from the global calendar pool or the resource calendar pool.
|
CreateDate
|
dateTime
|
X
|
X
|
The date this resource was created.
|
CreateUser
|
string
|
X
|
X
|
The name of the user that created this resource.
|
CurrencyId
|
string restricted to maxLength(6)
|
X
|
X
|
The unique currency abbreviation for the currency associated with this resource.
|
CurrencyName
|
string restricted to maxLength(40)
|
X
|
X
|
The name of the currency associated with this resource.
|
CurrencyObjectId
|
int
|
|
X
|
The unique ID of the currency associated with this resource.
|
DefaultUnitsPerTime
|
double restricted to minInclusive(0.0)
|
|
X
|
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
|
dateTime
|
X
|
|
the earliest day when the resource becomes overallocated, calculated during the summarization.
|
EmailAddress
|
string restricted to maxLength(120)
|
|
X
|
The e-mail address for the resource.
|
EmployeeId
|
string restricted to maxLength(40)
|
|
X
|
The resource identifier within the organization, typically the employee number or social security number.
|
GUID
|
string restricted to pattern '\{[0-9a-fA-F]{8}-[0-9a-fA-F]{4}-[0-9a-fA-F]{4}-[0-9a-fA-F]{4}-[0-9a-fA-F]{12}\}|'
|
|
X
|
The globally unique ID generated by the system.
|
Id
|
string restricted to maxLength(20)
|
|
X
|
The short code that uniquely identifies the resource.
|
IntegratedType
|
string restricted to '' 'ERP' 'Fusion'
|
|
X
|
The flag indicating 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
|
boolean
|
|
X
|
The flag that indicates whether the resource is currently active. Non-active resources may have left the organization but are not deleted from the system since they may have actual hours.
|
IsOverTimeAllowed
|
boolean
|
|
X
|
The flag that indicates whether the resource is allowed to log overtime hours.
|
LastUpdateDate
|
dateTime
|
X
|
X
|
The date this resource was last updated.
|
LastUpdateUser
|
string
|
X
|
X
|
The name of the user that last updated this resource.
|
MaxUnitsPerTime
|
double
|
X
|
|
The maximum work units per time this resource can perform on all their assigned activities. For example, a person working full time could perform 8 hours of work per day. A department of five people may perform at 5 days per day.
|
Name
|
string restricted to maxLength(100)
|
|
X
|
The name of the resource.
|
ObjectId
|
int
|
|
X
|
The unique ID generated by the system.
|
OfficePhone
|
string restricted to maxLength(32)
|
|
X
|
The office phone number for the resource.
|
OtherPhone
|
string restricted to maxLength(32)
|
|
X
|
The other phone numbers for the resource - pager, home phone, cell phone, etc.
|
OvertimeFactor
|
double restricted to minInclusive(0.0) maxInclusive(10.0)
|
|
X
|
The overtime factor used to compute the overtime price for the resource.
|
ParentObjectId
|
int
|
|
X
|
The unique ID of the parent resource of this resource in the hierarchy.
|
PricePerUnit
|
double
|
X
|
|
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
|
string restricted to maxLength(20)
|
X
|
X
|
The short code that uniquely identifies the primary role for this resource.
|
PrimaryRoleName
|
string restricted to maxLength(100)
|
X
|
X
|
The name of the primary role for this resource
|
PrimaryRoleObjectId
|
int
|
|
X
|
The unique ID of the role that is assigned as the resource's primary role.
|
ResourceNotes
|
string
|
|
|
The notes about the resource.
|
ResourceType
|
string restricted to 'Labor' 'Nonlabor' 'Material'
|
|
X
|
The resource type: "Labor", "Nonlabor", or "Material".
|
SequenceNumber
|
int
|
|
X
|
The sequence number for sorting.
|
ShiftObjectId
|
int
|
|
X
|
The unique ID of the shift associated with the resource.
|
TimesheetApprovalManager
|
string
|
X
|
|
The resource manager assigned to approve timesheets for the resource.
|
TimesheetApprovalManagerObjectId
|
int
|
|
X
|
The unique ID of the resource manager assigned to approve timesheets for the resource.
|
Title
|
string restricted to maxLength(100)
|
|
X
|
The title of the resource.
|
UnitOfMeasureObjectId
|
int
|
|
X
|
The unit of measure this material resource uses.
|
UseTimesheets
|
boolean
|
|
X
|
The flag that indicates whether the resource uses timesheets.
|
UserName
|
string restricted to maxLength(32)
|
X
|
X
|
The user's login name.
|
UserObjectId
|
int
|
|
X
|
The unique ID of the associated user.
|