db_project
- Former user (Deleted)
- Rashmi Likhite
- Former user (Deleted)
- Sanket Pai (Unlicensed)
Owned by Former user (Deleted)
Describes a project
| 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 |
| type_id | Integer | db_project_category.id | ID of its project category |
| workspace_id | Integer | db_group.id | ID of the 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. |
| name | String | Â | Short name of this project |
| description | String | Â | Detail |
| markdown_detail | String | Â | Detail |
| billing_type | Integer | Â | Â |
| fixed_price | Float | Â | Â |
| budget | Float | Â | Budget |
| 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 |
| state_id | Integer | db_project_state.id | Â |
| projected_hours | Float | Â | Projected cost |
| projected_cost | Float | Â | Projected cost |
| projected_finish | Date | Â | Projected finish date |
| planned_start | Date | Â | Planned start date of this project |
| planned_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 |
| actual_percent_complete | Integer | Â | % complete |
| actual_fixed_cost | Float | Â | Accumulated fixed cost for this project |
| actual_labor_cost | Float | Â | Accumulated user cost for this project |
| actual_cost | Float | Â | Total accumulated cost |
| actual_costable_expense | Float | Â | Total costable expense |
| actual_non_costable_expense | Float | Â | Total non-costable expense |
| actual_billable_expense | Float | Â | Total billable expense |
| actual_non_billable_expense | Float | Â | Total non-billable expense |
| planned_effort | Float | Â | Total estimated work in minutes |
| planned_labor_revenue | Float | Â | Estimated labour billing |
| planned_labor_cost | Float | Â | Total estimated labour cost |
| planned_non_labor_cost | Float | Â | Total estimated non-labour cost |
| planned_fixed_cost | Float | Â | Total estimated fixed cost |
| actual_billable_labor_amount | Float | Â | Total billable time sheet billing |
| actual_non_billable_labor_amount | Float | Â | Total non-billable time sheet billing |
| actual_billable_labor_hours | Float | Â | Billable time sheet hours |
| actual_non_billable_labor_hours | Float | Â | Non-billable time sheet hours |
| actual_costable_labor_hour | Float | Â | Costable time sheet hours |
| invoiced_expense | Float | Â | Total invoiced expense |
| invoiced_labor_amount | Float | Â | Total invoiced time |
| invoiced_labor_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 |