projecttask
Stores individual project tasks, used for task tracking, resource allocation, and scheduling.
Columns
| Name | Type | References | Description |
| id [KEY] | Integer | A unique internal identifier assigned to the record, used for tracking and referencing the entry within the system. | |
| actualwork | Double | The actual amount of work completed on the task or project, typically measured in hours or units of work. | |
| constrainttype | String | The type of constraint applied to the task or project, such as 'must start on', 'finish no later than', or other scheduling constraints. | |
| contact | String | The contact person associated with the task or project, typically the person responsible for communication or project oversight. | |
| enddate | Date | The date when the task or project is scheduled to be completed, marking the end of the planned duration. | |
| enddatebaseline | Date | The original or baseline end date for the task or project, used for comparison with the actual end date to track progress. | |
| estimatedwork | Double | The estimated amount of work required to complete the task or project, often used in planning and scheduling. | |
| estimatedworkbaseline | Double | The original or baseline estimated work for the task or project, used as a reference for comparing against actual performance. | |
| eventid | Integer | A unique identifier for the project task or event, used to track and reference the specific task within the project. | |
| externalid | String | A unique identifier for the record assigned by an external system, used for integration or synchronization across platforms. | |
| finishbydate | Date | The date by which the task or project must be finished, used to track deadlines and manage project timelines. | |
| ismilestone | Boolean | Indicates whether the task is a milestone, used to mark significant events or achievements within the project. | |
| issummarytask | Boolean | Indicates whether the task is a summary task, used to represent a group of related tasks or a higher-level view of the project. | |
| message | String | Comments or notes associated with the task or project, often used for additional context or communication among team members. | |
| nonbillabletask | Boolean | Indicates whether the task is non-billable, often used to track internal tasks or those that are not part of client billing. | |
| owner | String | The person or entity responsible for the task or project, often the creator or the individual assigned to oversee the work. | |
| parent | String | The parent task associated with the record, used to define hierarchical relationships between tasks or subtasks. | |
| percenttimecomplete | Double | The percentage of the task or project that has been completed, used for progress tracking and reporting. | |
| priority | String | The priority level of the task or project, indicating its importance relative to other tasks or projects. | |
| project | String | The project associated with the task, used to track the job or initiative under which the task is being completed. | |
| remainingwork | Double | The amount of work remaining to complete the task or project, often calculated as the difference between total work and completed work. | |
| startdatebaseline | Date | The original or baseline start date for the task or project, used for tracking deviations from the planned schedule. | |
| startdatetime | Date | The start date and time for the task or project, marking the beginning of the work or project phase. | |
| status | String | The current status of the task or project, such as 'not started', 'in progress', 'completed', or 'delayed'. | |
| title | String | The name or title of the task or project, typically used for identification or display purposes in user interfaces or reports. |