db_task
Describes a task
| Column | Type | References | Comments |
|---|---|---|---|
| id | Integer | Primary key | |
| guid | String | ||
| vdb_id | Integer | ||
| project_id | Integer | db_project.id | ID this task's project |
| parent_id | Integer | db_task.id | Parent ID |
| folder_id | Integer | db_folder.id | Document folder ID |
| priority | Integer | Priority. 1 for highest 5 for lowest | |
| summary | String | Short name | |
| detail | String | Detailed description | |
| flags | Integer | Bit string of flags | |
| duration_value | Float | Duration value (e.g. if duration is 2.5days this field will be 2.5) | |
| actual_start | Date | Actual start | |
| schedule_type_value | Integer | ||
| 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 | |
| is_manual | Boolean (t or f) | True if manually scheduled | |
| is_hold | Boolean (t or f) | True if on hold | |
| early_start | Date | Early start | |
| early_finish | Date | Early finish | |
| late_start | Date | Late start | |
| late_finish | Date | Late finish | |
| actual_finish | Date | Actual finish | |
| percent_complete | Integer | % complete | |
| percent_complete_method | Integer | % complete method | |
| budget | Float | Budget | |
| fixed_cost | Float | Fixed cost | |
| est_non_labour_cost | Float | Estimated non labour cost | |
| work_time | Float | Effort in minutes | |
| my_b_time_money | Float | Total billable time entries billing | |
| ru_b_time_money | Float | Total rolled-up billable time entries billing | |
| my_nb_time_money | Float | Total non-billable time entries billing | |
| ru_nb_time_money | Float | Total rolled-up non-billable time entries billing | |
| my_nb_time_hours | Float | Total non-billable time (hours) | |
| ru_nb_time_hours | Float | Total rolled-up non-billable time (hours) | |
| my_b_time_hours | Float | Total billable time (hours) | |
| ru_b_time_hours | Float | Total rolled-up billable time (hours) | |
| my_c_time_hours | Float | Total costable time (hours) | |
| ru_c_time_hours | Float | Total rolled-up costable time (hours) | |
| my_b_expense | Float | Total billable expense | |
| ru_b_expense | Float | Total rolled-up billable expense | |
| my_nb_expense | Float | Total non billable expense | |
| ru_nb_expense | Float | Total rolled-up non billable expense | |
| my_c_expense | Float | Total costable expense | |
| ru_c_expense | Float | Total rolled-up costable expense | |
| my_nc_expense | Float | Total non costable expense | |
| ru_nc_expense | Float | Total rolled-up non costable expense | |
| my_i_expense | Float | Total invoiced expense | |
| ru_i_expense | Float | Total rolled-up invoiced expense | |
| my_i_time_money | Float | Total invoiced time | |
| ru_i_time_money | Float | Total rolled-up invoiced time | |
| my_i_time_hours | Float | Total invoiced hours | |
| ru_i_time_hours | Float | Total rolled-up invoiced hours | |
| my_est_cost | Float | Estimated cost to complete this task | |
| ru_est_cost | Float | Rolled-up estimated cost to complete this task and its descendants | |
| my_est_labour_cost | Float | Estimated labour cost | |
| ru_est_labour_cost | Float | Rolled-up estimated labour cost | |
| my_labour_cost | Float | Actual labour cost till now | |
| ru_labour_cost | Float | Rolled-up actual labour cost till now | |
| my_cost | Float | Actual cost for this task | |
| ru_cost | Float | Actual cost for this task's descendants | |
| my_est_labour_billing | Float | Estimated labour billing for this task | |
| ru_est_labour_billing | Float | Estimated labour billing for this task's descendants | |
| billing_amount | Float | ||
| 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 | |
| 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 | |
| is_duration_estimated | Boolean (t or f) | Is the duration an approximation | |
| is_duration_elapsed | Boolean (t or f) | Is the duration calendar elapsed time | |
| projected_start_date | Date | Projected start date | |
| projected_deadline | Date | Projected deadline | |
| project_state_id | Integer | State of this task's project | |
| archived | Date | Date when project was archived | |
| child_number | Integer | Number in siblings | |
| local_key | Integer | ||
| 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 | |
| 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 | |
| document_count | Integer | Total number of documents associated with this task | |
| projected_start | Date | Projected start date | |
| projected_finish | Date | Projected finish date | |
| followers_csv | String | Person ID CSV (-1 means project team), (-2 means PM) | |
| 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 | |