Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Describes resource assignment for this task

ColumnTypeReferencesComments
idInteger Primary key
vdb_idInteger  
user_idIntegerdb_person.idUser ID
allocation_unit
_type_value
Integer Assignment unit type 1 = %age, 2 = hours
units
allocation_valueFloat Units assigned to the resource
project_idIntegerdb_project.idProject ID
task_idIntegerdb_task.idTask ID
work
planned_
time
effortFloat Effort
est
planned_costFloat Estimated cost
est
planned_
labour
labor_
billing
revenueFloat Estimated billing
labour
actual_labor_costFloat Actual labour cost
time
actual_labor_hoursFloat Actual hours (approved)
time_money
actual_billable_labor_amountFloat Actual billing (approved)
submitted_labor_hoursFloat Submitted hours (approved + for approval)
start_utcDate Start of assignment
finish_utcDate End of assignment