Read ResourceHour
get
/resourceHour
Reads ResourceHour objects from the database.
Request
Query Parameters
-
Fields(required): string
Fields to loadExample:
Name,ObjectId
-
Filter(required): string
Supported Filter Operators - :gt:, :lt:, :eq:, :gte:, :lte:, :and:, :or:Example:
ObjectId IN(1,2) :and: CreateDate:gte:'2021-04-20' :and: LastUpdateDate:lt:'2022-04-20' :and: Name :like: 'abc%'
-
OrderBy(required): string
OrderBy conditionExample:
ObjectId desc
Header Parameters
-
Authorization(required):
OAuth token
There's no request body for this operation.
Back to TopResponse
Supported Media Types
- application/json
200 Response
OK.
Root Schema : List<ResourceHour>
Type:
array
Title:
Show Source
List<ResourceHour>
-
Array of:
object ResourceHour
Title:
ResourceHour
ResourceHour Entity
Nested Schema : ResourceHour
Type:
object
Title:
ResourceHour
ResourceHour Entity
Show Source
-
ActivityObjectId: integer
(int32)
The unique ID of the activity to which the resource is assigned.
-
ActivityTimesheetLinkFlag: boolean
The value which indicates if the record is a real timesheet entry (false) or simply a placeholder for a timesheet entry (true).
-
ApprovedHours: number
(double)
The number of hours, approved.
-
ApprovedOvertimeHours: number
(double)
The number of overtime hours, approved.
-
CreateDate: string
(date-time)
The date this data was created.
-
CreateUser: string
The name of the user that created this data.
-
Date: string
(date-time)
The date to which the hours apply.
-
IsBaseline: boolean
The boolean value indicating if this business object is related to a Project or Baseline
-
IsTemplate: boolean
The boolean value indicating if this business object is related to a template Project.
-
LastUpdateDate: string
(date-time)
The date this data was last updated.
-
LastUpdateUser: string
The name of the user that last updated this data.
-
ObjectId: integer
(int32)
The unique ID generated by the system.
-
OverheadCodeName: string
The name of the overhead code.
-
OverheadCodeObjectId(required): integer
(int32)
The unique ID of the overhead code, if the hours are for an overhead activity.
-
ProjectId: string
The short code that uniquely identifies the project.
-
ProjectName: string
The name of the associated project.
-
ProjectObjectId: integer
(int32)
The unique ID of the associated project.
-
ResourceAssignmentObjectId(required): integer
(int32)
The unique ID of the associated resource assignment.
-
ResourceId: string
The short code that uniquely identifies the resource.
-
ResourceIntegratedType: string
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
The name of the resource.
-
ResourceObjectId(required): integer
(int32)
The unique ID of the associated resource.
-
Status: string
The approval level, when timesheets require approval: 'Submitted', 'Approved', 'Resource Manager Approved', 'Project Manager Approved', 'Active', or 'Rejected'.
-
TimesheetPeriodObjectId(required): integer
(int32)
The unique ID of the associated timesheet.
-
TimesheetStatusDate: string
(date-time)
The status date of the associated timesheet.
-
UnapprovedHours: number
(double)
The actual non-overtime units submitted by the resource on the activity. These units remain submitted until the timesheet is approved.
-
UnapprovedOvertimeHours: number
(double)
The actual overtime units submitted by the resource on the acitivity. These units remain submitted until the timesheet is approved.
-
WBSObjectId: integer
(int32)
The unique ID of the WBS for the activity.
400 Response
Bad Request.
401 Response
Unauthorized.
403 Response
Forbidden.
404 Response
Not Found.
405 Response
Invalid Input.
500 Response
Internal Server Error.