db_assignment
- Former user (Deleted)
- Rashmi Likhite
- Former user (Deleted)
Owned by Former user (Deleted)
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 |