ASSIGN – This table holds all assignments for Track-IT pro (except for global assignments.)
Ÿ ID – The unique ID for an assignment. (PK)
Ÿ PROJECT – The ID for the project this assignment relates to. (FK)
Ÿ TASK – The ID for the task this assignment relates to. (FK)
Ÿ GROUP – The ID for a group this assignment relates to. (FK)
Ÿ GPAR – The ID for a group parent this assignment relates to. (FK)
Ÿ EMPLOYEE – The ID for an employee this assignment relates to. (FK)
Ÿ EST – "T" if this is an estimate assignment "F" otherwise.
Ÿ HOURS – The number of estimated hours.
Ÿ ADJHOURS – The adjustment to the estimated hours.
Ÿ EMPRATE – The employees charge amount.
Ÿ EMPCOST – The employees wage amount.
Ÿ PRORATE – The prorating for this estimate.
Ÿ TARGET – The target for the estimate.
Ÿ RATEID – The ID for the charge amount.
Ÿ COSTID – The ID for the wage amount.
Ÿ HIDE – "T" if the item should be hidden from assignments, "F" otherwise.
Ÿ ETC – The Estimated Time for Completion
Ÿ START – The start date for the assignment.
Ÿ FINISH – The end date of the assignment.
Ÿ WBS – The Work Break Down Structure code.