Describes a process
Column | Type | References | Comments |
id | Integer | Primary key | |
guid | String | ||
vdb_id | Integer | ||
created | Date | Date created | |
summary | String | Short summary | |
detail | 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 |
requestor_name | String | Requestor name (in case requestor is not a user of the system) | |
requestor_email | String | Requestor email (in case requestor is not a user of the system) | |
creator_id | Integer | db_person.id | Creator ID |
assigned_to_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_b_time_money | Float | Total billable time entries billing | |
my_b_time_hours | Float | Total billable time (hours) | |
my_nb_time_money | Float | Total non-billable time entries billing | |
my_nb_time_hours | Float | Total non-billable time (hours) | |
my_c_time_hours | Float | Total costable time (hours) | |
my_i_time_money | Float | Total invoiced time | |
my_i_time_hours | Float | Total invoiced hours | |
my_labour_cost | Float | Actual labour cost for this process | |
my_cost | Float | Actual cost for this process | |
time_entry_count | Integer | Total number of time entries associated with this process |