Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

Version 1 Next »

Describes resource assignment for this task

ColumnTypeReferencesComments
idInteger Primary key
vdb_idInteger  
user_idIntegerdb_person.idUser ID
unit_type_valueInteger Assignment unit type 1 = %age, 2 = hours
unitsFloat Units assigned to the resource
project_idIntegerdb_project.idProject ID
task_idIntegerdb_task.idTask ID
work_timeFloat Effort
est_costFloat Estimated cost
labour_costFloat Actual labour cost
time_hoursFloat Actual hours (approved)
time_moneyFloat Actual billing (approved)
submitted_hoursFloat Submitted hours (approved + for approval)
start_utcDate Start of assignment
finish_utcDate End of assignment
  • No labels