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 | Decimal | 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 | Decimal | 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. | |
| fullname | String | The full hierarchical name of the task, including any parent tasks or projects, used to uniquely identify the task within the overall project structure. | |
| allocatedwork | Decimal | The amount of work allocated to the task based on resource assignments, typically measured in hours or units of work. | |
| calculatedwork | Decimal | The system-calculated amount of work for the task, derived from resource allocations and scheduling rather than entered manually. | |
| calculatedworkbaseline | Decimal | The original or baseline value of the system-calculated work for the task, used as a reference for comparing against current calculated work. | |
| plannedwork | Decimal | The amount of work planned for the task, used in scheduling and resource planning. | |
| plannedworkbaseline | Decimal | The original or baseline planned work for the task, used as a reference for comparing against the current planned work. | |
| plannedworktotal | Decimal | The total planned work for the task, aggregating planned work across all resources or subtasks. | |
| estimatedcost | Decimal | The estimated cost of completing the task, expressed in the transaction currency. | |
| estimatedcostbase | Decimal | The estimated cost of completing the task, expressed in the base currency of the subsidiary or company. | |
| estimatedcostbaseline | Decimal | The original or baseline estimated cost of the task, used as a reference for comparing against the current estimated cost. | |
| estimatedcostbasebaseline | Decimal | The original or baseline estimated cost of the task, expressed in the base currency, used for cost variance comparisons. | |
| duration | Decimal | The total duration of the task, typically measured in hours or days, representing the length of time allocated to complete the work. | |
| estimatedhoursatcompletion | Decimal | The estimated total number of hours the task will require at completion, combining actual and remaining work. | |
| estimatedhourstocomplete | Decimal | The estimated number of hours remaining to complete the task, used for forecasting and resource planning. | |
| slackminutes | Decimal | The amount of scheduling slack for the task, measured in minutes, indicating how much the task can be delayed without affecting the project timeline. | |
| percentcompletebyrsrcalloc | Decimal | The percentage of the task completed based on allocated work, used for progress tracking relative to resource assignments. | |
| lastmodifieddate | Datetime | The date and time when the record was last modified, used for tracking changes and synchronization. | |
| isinactive | Boolean | Indicates whether the task is inactive, used to exclude the task from active project tracking and reporting. | |
| isoncriticalpath | Boolean | Indicates whether the task is on the critical path of the project, meaning any delay to the task will delay the overall project completion. | |
| bbudgetusecalculatedvalues | Boolean | Indicates whether calculated values are used for all labor billing budgets on the task, rather than manually entered budget amounts. | |
| cbudgetusecalculatedvalues | Boolean | Indicates whether calculated values are used for all labor cost budgets on the task, rather than manually entered budget amounts. |