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 |
| unit_type_value | Integer | Â | Assignment unit type 1 = %age, 2 = hours |
| units | Float | Â | Units assigned to the resource |
| project_id | Integer | db_project.id | Project ID |
| task_id | Integer | db_task.id | Task ID |
| work_time | Float | Â | Effort |
| est_cost | Float | Â | Estimated cost |
| est_labour_billing | Float | Â | Estimated billing |
| labour_cost | Float | Â | Actual labour cost |
| time_hours | Float | Â | Actual hours (approved) |
| time_money | Float | Â | Actual billing (approved) |
| submitted_hours | Float | Â | Submitted hours (approved + for approval) |
| start_utc | Date | Â | Start of assignment |
| finish_utc | Date | Â | End of assignment |