Resource_allocations

The CRM Fields custom field is available for the Resource Allocations table.

Columns

Name Type Length Precision Scale References In Description
allocation_type VARCHAR2 200 Type of allocation (Soft or Hard)
allocation_unit VARCHAR2 1 Allocation unit (H for hours, P for percentage of time)
customer_id NUMBER 39 0 Customer for which the resource is allocated
date_last_modified TIMESTAMP Last modification date
end_date TIMESTAMP End date
is_inactive VARCHAR2 3 Inactive
notes VARCHAR2 4000 Notes
num_hours NUMBER 10 4 Number of hours
num_percent NUMBER 12 4 Percentage of allocated working time (based on resource's working calendar)
project_id NUMBER 39 0 Project for which the resource is allocated
project_task_id NUMBER 39 0 Project task ID
requestor_id NUMBER 39 0 Requestor (owner) of the allocation
resource_allocation_extid VARCHAR2 255 Resource allocation external ID
resource_allocation_id NUMBER 39 0 Resource allocation ID
resource_id NUMBER 39 0 Allocated resource (employee/vendor)
start_date TIMESTAMP Start date