CData Python Connector for Oracle Fusion Cloud Financials

Build 25.0.9454

ProjectResourceActualHours

The Project Resource Actual Hours resource is used to view and create actual hours for a resource.

Columns

Name Type Description
TransactionId [KEY] Long Unique identifier of the actual hours record.
ResourceId Long Identifier of the project enterprise resource who reported actual hours worked.
ResourceEmail String Email of the project enterprise resource who reported actual hours worked.
HCMPersonId Long HCM Person identifier of the project enterprise resource for which actual hours are reported.
ResourceName String Name of the project enterprise resource who reported actual hours worked.
WorkDate Date Date on which the project enterprise resource worked.
UtilizationDate Date Date that's associated with the actual hours worked for utilization reporting purposes. If no value is specified, then the utilization date is based on the work date.
ProjectId Long Identifier of the project for which the project enterprise resource reported the actual hours worked.
ProjectNumber String Number of the project for which the project enterprise resource reported the actual hours worked.
ProjectName String Name of the project for which the project enterprise resource reported the actual hours worked.
TaskId Long Identifier of the task for which the project enterprise resource reported actual hours worked.
TaskName String Name of the task for which the project enterprise resource reported actual hours worked.
ActualHoursWorkedCategory String Type of activity that's represented by the actual hours. Examples are Project Work, Paid Time Off, Training, and Other.
ActualHoursWorkedCategoryCode String Code for the type of activity that's represented by the actual hours. Examples are PROJECT_WORK, PTO, TRAINING, and OTHER.
Quantity Decimal Total actual hours worked that the resource reports for a day. The actual hours worked can be positive or negative with a maximum of two decimal places.
Comments String Information about the actual hours reported.
UtilizationFlag Bool Indicates whether the actual hours reported are eligible to be included in utilization calculations for the resource. Valid values are Y or N. It will default to Y if ActualHoursWorkedCategoryCode is PROJECT_WORK and to N if ActualHoursWorkedCategoryCode is PTO,TRAINING or OTHER.
BillableUtilizationFlag Bool Indicates whether the actual hours reported will be included in billable resource utilization calculation. Valid values are Y or N. If no value is provided, it will default to Y if ActualHoursWorkedCategoryCode is PROJECT_WORK and to N if ActualHoursWorkedCategoryCode is PTO,TRAINING or OTHER.
OriginalTransactionReference String Reference to the transaction details in the originating source system.
AdjustmentEntryFlag Bool Indicates if the actual hours reported represent an adjustment to existing actual hours for a resource. This attribute is set to N during POST operation if no value is specified.
AdjustedTransactionReference String Reference to the original transaction that this transaction adjusts, if this transaction is for an adjustment. This is an optional value even for an adjustment transaction.
Finder String finder

Copyright (c) 2025 CData Software, Inc. - All rights reserved.
Build 25.0.9454