db_process
- Former user (Deleted)
- Rashmi Likhite
- Sanket Pai (Unlicensed)
- Former user (Deleted)
Owned by Former user (Deleted)
Describes a process
| Column | Type | References | Comments |
| id | Integer | Â | Primary key |
| guid | String | Â | Â |
| vdb_id | Integer | Â | Â |
| created | Date | Â | Date created |
| name | String | Â | Short summary |
| description | String | Â | Detailed description |
| due_date | Date | Â | Due date |
| is_delayed | Boolean (t or f) | Â | Is this process delayed? |
| priority | Integer | Â | Priority : 1 = highest, 5 = lowest |
| type_id | Integer | db_process_type.id | Process type ID |
| workspace_id | Integer | db_group.id | Workspace ID |
| project_id | Integer | db_project.id | Project ID |
| last_state_changed | Date | Â | Last state change on |
| last_updated | Date | Â | Last process update on |
| requestor_id | Integer | db_person.id | Requestor ID |
| external_requestor_name | String | Â | Requestor name (in case requestor is not a user of the system) |
| external_requestor_email | String | Â | Requestor email (in case requestor is not a user of the system) |
| creator_id | Integer | db_person.id | Creator ID |
| assignee_id | Integer | db_person.id | Current owner |
| state_id | Integer | db_state.id | State this process is in |
| completed | Date | Â | Completed on |
| followers_csv | String | Â | Person ID CSV (-1 means project team), (-2 means PM) |
| is_requestor_visible | Boolean (t or f) | Â | Is visible to requestor? |
| my_actual_billable_labor_amount | Float | Â | Total billable time entries billing |
| my_actual_billable_labor_hours | Float | Â | Total billable time (hours) |
| my_actual_non_billable_labor_amount | Float | Â | Total non-billable time entries billing |
| my_actual_non_billable_labor_hours | Float | Â | Total non-billable time (hours) |
| my_actual_costable_labor_hours | Float | Â | Total costable time (hours) |
| my_invoiced_labor_amount | Float | Â | Total invoiced time |
| my_invoiced_labor_hours | Float | Â | Total invoiced hours |
| my_actual_labor_cost | Float | Â | Actual labour cost for this process |
| my_actual_cost | Float | Â | Actual cost for this process |
| time_entry_count | Integer | Â | Total number of time entries associated with this process |