ResourceHour Fields


 Field


 Type

Read 
Only

Filterable
Orderable


 Description

ActivityObjectId

int

X

X

The unique ID of the activity to which the resource is assigned.

ActivityTimesheetLinkFlag

boolean

 

X

the value which indicates if the record is a real timesheet entry (false) or simply a placeholder for a timesheet entry (true).

ApprovedHours

double

 

X

The number of hours, approved.

ApprovedOvertimeHours

double

 

X

The number of overtime hours, approved.

CreateDate

dateTime

X

X

The date this data was created.

CreateUser

string

X

X

The name of the user that created this data.

Date

dateTime

 

X

The date to which the hours apply.

IsBaseline

boolean

X

X

The boolean value indicating if this business object is related to a Project or Baseline

IsTemplate

boolean

X

X

The boolean value indicating if this business object is related to a template Project.

LastUpdateDate

dateTime

X

X

The date this data was last updated.

LastUpdateUser

string

X

X

The name of the user that last updated this data.

ObjectId

int

 

X

The unique ID generated by the system.

OverheadCodeName

string
restricted to
maxLength(32)

X

X

The name of the overhead code.

OverheadCodeObjectId

int

 

X

The unique ID of the overhead code, if the hours are for an overhead activity.

ProjectId

string
restricted to
maxLength(40)

X

X

The short code that uniquely identifies the project.

ProjectName

string
restricted to
maxLength(100)

X

X

The name of the associated project.

ProjectObjectId

int

 

X

The unique ID of the associated project.

ResourceAssignmentObjectId

int

 

X

The unique ID of the associated resource assignment.

ResourceId

string
restricted to
maxLength(255)

X

X

The short code that uniquely identifies the resource.

ResourceIntegratedType

string
restricted to
''
'ERP'
'Fusion'
'Gateway'
'PrimaveraCloudScope'

 

X

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. 'Gateway' indicates the resource is integrated with Oracle Primavera Gateway.

ResourceName

string
restricted to
maxLength(255)

X

X

The name of the resource.

ResourceObjectId

int

 

X

The unique ID of the associated resource.

Status

string
restricted to
''
'Submitted'
'Approved'
'Resource Manager Approved'
'Project Manager Approved'
'Active'
'Rejected'
'Resubmitted'
'Reopened'
'Submitted for RM'
'Resubmitted for RM'

 

X

The approval level, when timesheets require approval: 'Submitted', 'Approved', 'Resource Manager Approved', 'Project Manager Approved', 'Active', or 'Rejected'.

TimesheetPeriodObjectId

int

 

X

The unique ID of the associated timesheet.

TimesheetStatusDate

dateTime

X

X

The status date of the associated timesheet.

UnapprovedHours

double

 

X

The actual non-overtime units submitted by the resource on the activity. These units remain submitted until the timesheet is approved.

UnapprovedOvertimeHours

double

 

X

The actual overtime units submitted by the resource on the acitivity. These units remain submitted until the timesheet is approved.

WBSObjectId

int

X

 

The unique ID of the WBS for the activity.



Legal Notices | Your Privacy Rights
Copyright © 2008, 2023

Last Published Wednesday, February 1, 2023