Describes a task
| Column | Type | References | Comments |
|---|---|---|---|
| id | Integer | Primary key | |
| vdb_id | Integer | ||
| project_id | Integer | db_project.id | ID this task's project |
| parent_id | Integer | db_task.id | Parent ID |
| company_id | Integer | db_company.id | |
| folder_id | Integer | Document folder ID | |
| priority | Integer | Priority. 1 for highest 5 for lowest | |
| summary | String | Short name | |
| detail | String | Detailed description | |
| duration_value | Float | Duration value (e.g. if duration is 2.5days this field will be 2.5) | |
| actual_start | Date | Actual start | |
| plan_start | Date | Planned start | |
| plan_finish | Date | Planned finish | |
| is_critical | Boolean (t or f) | True if task is on critical path | |
| is_milestone | Boolean (t or f) | True if milestone | |
| early_start | Date | Early start | |
| early_finish | Date | Early finish | |
| late_start | Date | Late start | |
| late_finish | Date | Late finish | |
| completed_on | Date | Actual finish | |
| percent_complete | Integer | % complete | |
| b_expense_total | Float | Total billable expense | |
| nb_expense_total | Float | Total non billable expense | |
| b_timesheet_total | Float | Total billable time entries billing | |
| nb_timesheet_total | Float | Total non-billable time entries billing | |
| ru_b_expense_total | Float | Total rolled-up billable expense | |
| ru_nb_expense_total | Float | Total rolled-up non billable expense | |
| ru_b_timesheet_total | Float | Total rolled-up billable time entries billing | |
| ru_nb_timesheet_total | Float | Total rolled-up non-billable time entries billing | |
| budget | Float | Budget | |
| est_cost | Float | Estimated cost to complete this task | |
| ru_est_cost | Float | Rolled-up estimated cost to complete this task and its descendants | |
| est_non_labor_cost | Float | Estimated non labour cost | |
| est_labor_cost | Float | Estimated labour cost | |
| ru_est_labor_cost | Float | Rolled-up estimated labour cost | |
| fixed_cost | Float | Fixed cost | |
| user_cost | Float | Actual labour cost till now | |
| ru_user_cost | Float | Rolled-up actual labour cost till now | |
| can_fill_time | Boolean (t or f) | Can fill time on this task? | |
| is_dep_solved | Boolean (t or f) | Have all predecessors finished? | |
| last_status_update | Date | Date of the last status update | |
| is_assigned | Boolean (t or f) | Is this task assigned to anyone | |
| nb_timesheet_hours | Float | Total non-billable time (hours) | |
| b_timesheet_hours | Float | Total billable time (hours) | |
| ru_nb_timesheet_hours | Float | Total rolled-up non-billable time (hours) | |
| ru_b_timesheet_hours | Float | Total rolled-up billable time (hours) | |
| c_timesheet_hours | Float | Total costable time (hours) | |
| ru_c_timesheet_hours | Float | Total rolled-up costable time (hours) | |
| constraint_date | Date | Constraint date | |
| constraint_type_value | Integer | Constraint type: 1 = ASAP, 2 = ALAP, 3 = MSO, 4 = MFO, 5 = SNET, 6 = SNLT, 7 = FNET, 8 = FNLT. | |
| duration_type | Integer | Duration units: 1 = Day, 2 = Hour, 3 = Week, 4 = Month, 5 = Year, 6 = Minute | |
| is_summary | Boolean (t or f) | Is this a summary task i.e. does this task have any sub tasks | |
| assigned_work | Float | Assigned effort in minutes | |
| ru_assigned_work | Float | Rolled-up assigned effort in minutes | |
| is_duration_estimated | Boolean (t or f) | Is the duration an approximation | |
| projected_start_date | Date | Projected start date | |
| projected_deadline | Date | Projected deadline | |
| work_time | Float | Effort in minutes | |
| cost | Float | Accumulated cost for this task | |
| ru_cost | Float | Accumulated cost for this task's descendants | |
| project_phase_id | Integer | Phase of this task's project | |
| archived | Date | Date when project was archived | |
| child_number | Integer | Number in siblings | |
| local_key | Integer | ||
| billing_type | Integer | ||
| billing_amount | Float | ||
| tree_level | Integer | ||
| note_count | Integer | Total number of notes associated with this task | |
| message_count | Integer | Total number of email messages associated with this task | |
| phone_call_count | Integer | Total number of phone calls associated with this task | |
| status_update_count | Integer | Total number of task status updates associated with this task | |
| expense_count | Integer | Total number of expenses associated with this task | |
| time_entry_count | Integer | Total number of time entries associated with this task | |
| is_expanded | Boolean (t or f) | Is this task node expanded while displaying project tasks | |
| projected_start | Date | Projected start date | |
| projected_finish | Date | Projected finish date | |
| type_id | Integer | Task type ID | |
| state_id | Integer | Task type state ID | |
| COMPUTED COLUMNS: | |||
| spi | Float | The schedule performance index using earned value method | |
| cpi | Float | The cost performance index using earned value method | |
| bcws | Float | The budgeted cost of work scheduled using earned value method | |
| bcwp | Float | The budgeted cost of work performed using earned value method | |
| acwp | Float | The actual cost of work performed using earned value method | |
| schedule_status | String | The schedule status. Will be one of: ON_TIME, AT_RISK, OVERDUE, BLOCKED, FUTURE and COMPLETED | |
| budget_status | String | The budget status. Will be one of: ON_BUDGET, AT_RISK, OVER_BUDGET | |
| project_summary | String | The name of the project | |