Project_task_assignments

Columns

Name Type Length Precision Scale References In Description
allocated_work NUMBER 39 0 Allocated work
billing_class_id NUMBER 39 0 ID of the billing class under which the resource (employee/vendor) is assigned to certain project task .
calculated_work NUMBER 39 0 Current calculated work required for task
estimated_work NUMBER 39 0 Amount of time required from resource for project task
item_id NUMBER 39 0 Item ID (for service item)
planned_work NUMBER 39 0 Current planned work required for task
project_id NUMBER 39 0 Project ID
project_task_id NUMBER 39 0 Project task ID
resource_id NUMBER 39 0 Resource ID
unit_cost NUMBER 39 0 Cost per unit for resource
unit_cost_foreign NUMBER 39 0 Cost per unit for resource in foreign currency
unit_price NUMBER 39 0 Price charged per unit for resource
unit_price_foreign NUMBER 39 0 Price charged per unit for resource in foreign currency
units NUMBER 39 0 Percentage of resource used on task