WORKFLOW – This table contains all workflow processes in the Track-IT pro database.
Ÿ ID – The Unique ID for the workflow process. (PK)
Ÿ PROJECT – The ID of the project the Workflow is assigned to.
Ÿ TEMPLATE – The ID of the workflow that the Matrix Approval template is assigned to.
Ÿ EMPLOYEE – The ID of the Employee who made the Template private. (FK)
Ÿ NAME – The Name of the workflow process.
Ÿ TYPE – The Type of workflow process. (T = "Timesheet", E = "Expense")
Ÿ DESC = The description of the workflow process.
Ÿ ARCHIVE – "T" if the workflow 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 workflow is hidden in workflow lists, "F" otherwise.