db_assignment
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 | Integer | Assignment unit type 1 = %age, 2 = hours | |
| allocation_value | Float | Units assigned to the resource | |
| project_id | Integer | db_project.id | Project ID |
| task_id | Integer | db_task.id | Task ID |
| planned_effort | Float | Effort | |
| planned_cost | Float | Estimated cost | |
| planned_labor_revenue | Float | Estimated billing | |
| actual_labor_cost | Float | Actual labour cost | |
| actual_labor_hours | Float | Actual hours (approved) | |
| actual_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 |