...
| Column | Type | References | Comments | ||||
| id | Integer | Primary key | |||||
| code | String | A unique project code | |||||
| vdb_id | Integer | ||||||
| guid | String | ||||||
| created | Date | Date this project was created | |||||
| project_category_id | Integer | db_project_category.id | ID of its project category | ||||
| process_categoryworkspace_id | Integer | ID of its process category | department_id | Integer | db_group.id | ID of the department group this project belongs to | |
| working_calendar_id | Integer | ||||||
| client_id | Integer | db_person.id | Client ID | ||||
| manager_id | Integer | db_person.id | Primary Project Manager ID | ||||
| priority | Integer | Priority. 1 is for highest and 5 for lowest. | |||||
| summary | String | Short name of this project | |||||
| detail | String | Detail | |||||
| charging_model | Integer | ||||||
| ceiling_price | Float | ||||||
| start_price | Float | ||||||
| fixed_price | Float | ||||||
| budget | Float | Budgetcompany_id | |||||
| Integer | folder_id | Integer | db_folder.id | ID of its document folder | |||
| archived | Date | Date when the project is in an 'end' phase | |||||
| archived_by_id | Integer | ID of the user who archived this project | |||||
| phase_id | Integer | db_project_phase.id | Phase of this project: 1 - In Progress, 2 - On Hold, 3 - Completed, 4 - Planning | ||||
| 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 | |||||
| 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 | working_calendar_id | Integer | |||
| 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 | custom_field_string | String | (New column since v9.1) Includes a JSON formatted string of all custom fields attached to this entity | ||
| 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 | |||||