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 |
| 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 |