TASK table

 

TASK – This table stores all task information for the Track-IT pro database.

Ÿ      ID – The unique ID for a task. (PK)

Ÿ      NAME – The name for the task.

Ÿ      GROUP – The group ID for the task group the task belongs to. (FK)

Ÿ      LEADER – The manager for the task.

Ÿ      DESC – The description for the task.

Ÿ      GLOBAL – "T" if the task is global, "F" otherwise.

Ÿ      PRORATE – The multiplier for a task. Used in calculating client costs.

Ÿ      EFFDATE – The date the prorating is effective for.

Ÿ      TARGET – Reserved for future use.

Ÿ      ARCHIVE – "T" if the task is to be archived, "F" otherwise.

Ÿ      OUTSIDE – Can contain information not internally used by the software. Is used by the Import/Export tool, and can also be used for other customizable purposes.

Ÿ      HIDE – "T" if the task is hidden in task lists, "F" otherwise.

Ÿ      INTEGRATE – This field contains Quick Books link information, which is used internally by the software.