Versions Compared


  • This line was added.
  • This line was removed.
  • Formatting was changed.

Project Management consists of a few tables, some of which are described in this topic.

Projects Table

Purpose: This The Projects table holds records for project management activities. It is currently optimized for companies providing consulting services to their clients, and allows them to manage their billable and unbillable hours, work authorizations, and overall project status. It can easily be customized for internal project management instead.

Use Case

Members of the Admin or Project Manager groups may manually create Project records. Projects are creatable only in the "Planned", "Assigned", "Work in Progress" and "Awaiting Customer Feedback" states.


Project records are divided into two broad categories: Internal and Client-Related. These categories are further divided by type. The tasks that are automatically generated by a project depend on the type selected. For each Project type there are task templates that list the tasks that get automatically generated. The exact selection of tasks that will be generated can be specified on the "Tasks" tab of the Project record. Ad-hoc tasks can also be created using an action button on that tab. Additional fields are visible when a Project's Category is "Client-Related". These fields hold information about customer contracts, contact details, and authorized hours.
Main tab of Project record.
Time spent on the project is tracked on the "Time / Billing" tab. It includes a small form to enter time spent and a related table of time entries for this project. Time entries can be searched for in the related table and linked to the project manually.


Default workflow for the Projects table


Records in this table are " owned " by the Employee designated as the Project Manager.

Project Types Table

Purpose: This Project Types is a background table that holds the Project Types referenced by the Projects table. It allows the creation of new Project Types by Project Managers and other users without Admin group privileges.
Project Types define the task generation method, if any, and if task workflows will be used, they are defined in the project type record:.

Project Types screen.Image Modified

In addition to Predefined Task Workflows, project types may use Users Selected Tasks or User Generated Ad Hoc Tasks as the task generation methods.

Drop-down showing Task Generation Methods such as workflow or ad hoc.Image Modified
The differences between these methods is discussed in more detail in the Tasks for Service Requests section above, and the same options available for Service Requests apply to Projects. The methodology for setting up task workflows and the way in which the prerequisite tasks are handled is discussed above in the Task Workflows Table section and in the Task Templates section.

Purchase Orders (PO) Table

Purpose: The Purchase Order table tracks authorized billable hours for a project. It is shown as a related table within the Project table. It could easily be linked to support cases or Quotes or other tables within the system.


PO records are creatable manually via the web form, from within Project records in the related table, or via mass import. Only members of the Professional Services, Sales and admin Groups may create or import records. PO records are creatable in any workflow state.

Only members of the Professional Services, Sales and admin Groups may edit records, but Support Staff may view all PO records. Default workflow for the Purchase Orders tableImage Removed


Records in this table are " owned " by an Employee, generally the one who created the record. Each record is associated with a particular Employee login.