ASSIGN table

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.

Ÿ      TRABILLABLE – "T" to set this assignment’s time entries as default billable, "F" otherwise.