Describes resource assignment for this task
Column | Type | References | Comments |
---|
id | Integer | | Primary key |
vdb_id | Integer | | |
user_id | Integer | db_person.id | User ID |
allocation_unit |
_type_value | Integer | | Assignment unit type 1 = %age, 2 = hours |
unitsallocation_value | Float | | Units assigned to the resource |
project_id | Integer | db_project.id | Project ID |
task_id | Integer | db_task.id | Task ID |
worktimeestplanned_cost | Float | | Estimated cost |
estlabourbillingrevenue | Float | | Estimated billing |
labouractual_labor_cost | Float | | Actual labour cost |
timeactual_labor_hours | Float | | Actual hours (approved) |
time_moneyactual_billable_labor_amount | Float | | Actual billing (approved) |
submitted_labor_hours | Float | | Submitted hours (approved + for approval) |
start_utc | Date | | Start of assignment |
finish_utc | Date | | End of assignment |