| |
| projected_hours | Float | | Projected cost |
| projected_cost | Float | | Projected cost |
| projected_finish | Date | | Projected finish date |
| plan_start | Date | | Planned start date of this project |
| plan_finish | Date | | Planned finish date of this project. This will be the max of plan_finish of its tasks. |
| actual_finish | Date | | The time when all tasks report 100% |
| deadline | Date | | The deadline of this project |
| duration_hours | Float | | Duration of the project in hours |
| percent_complete | Integer | | % complete |
| fixed_cost | Float | | Accumulated fixed cost for this project |
| user_cost | Float | | Accumulated user cost for this project |
| cost | Float | | Total accumulated cost |
| c_expense | Float | | Total costable expense |
| nc_expense | Float | | Total non-costable expense |
| b_expense | Float | | Total billable expense |
| nb_expense | Float | | Total non-billable expense |
| est_work | Float | | Total estimated work in minutes |
| est_labour_billing | Float | | Estimated labour billing |
| est_labour_cost | Float | | Total estimated labour cost |
| est_non_labour_cost | Float | | Total estimated non-labour cost |
| est_fixed_cost | Float | | Total estimated fixed cost |
| b_time_money | Float | | Total billable time sheet billing |
| nb_time_money | Float | | Total non-billable time sheet billing |
| b_time_hours | Float | | Billable time sheet hours |
| nb_time_hours | Float | | Non-billable time sheet hours |
| c_time_hours | Float | | Costable time sheet hours |
| i_expense | Float | | Total invoiced expense |
| i_time_money | Float | | Total invoiced time |
| i_time_hours | Float | | Total invoiced hours |
| percent_complete_method | Integer | | Default % complete method for tasks |
| default_schedule_type | Integer | | Default schedule type for tasks |
| note_count | Integer | | Total number of notes associated with its tasks |
| message_count | Integer | | Total number of email messages associated with its tasks |
| status_update_count | Integer | | Total number of task status updates associated with its tasks |
| expense_count | Integer | | Total number of expenses associated with its tasks |
| time_entry_count | Integer | | Total number of time entries associated with its tasks |
| risk | Integer | | PPM risk. 1 is for Very Low and 5 for Very High. The potential negative impact that may arise from this project. |
| benefit | Integer | | Number between 0 to 100. The potential for financial or operational gain upon successful completion. |
| alignment | Integer | | Number between 0 to 100. The measure of how closely this project's requirements fit within the organizations business model, goals, skill sets, and resources. |
| default_baseline | Integer | | The default baseline to use in baseline comparisons |
| 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 |
| client_root_name | String | | The name of the client root in this project's client hierarchy |
| client_name | String | | The name of this project's client |
| manager_name | String | | The name of this project's manager |