Describes a process
| Column | Type | References | Comments | ||
| id | IntegerInteger | Primary Primary key | |||
| guid | StringString | ||||
| vdb_id | IntegerInteger | ||||
| created | DateDate | Date Date created | |||
| summary | StringString | Short Short summary | |||
| detail | StringString | Detailed Detailed description | |||
| due_date | DateDate | Due Due date | |||
| is_delayed | Boolean Boolean (t or f) | Is Is this process delayed? | |||
| priority | IntegerInteger | Priority Priority : 1 = highest, 5 = lowest | |||
| type_id | IntegerInteger | db_process_type.id | Process Process type ID | ||
| categoryworkspace_id | IntegerInteger | db_categorygroup.id | Category Workspace ID | ||
| departmentproject_id | Integer | ID of the department this project belongs toInteger | db_project.id | Project ID | |
| last_state_changed | DateDate | Last Last state change on | |||
| last_updated | DateDate | Last Last process update on | |||
| requestor_id | IntegerInteger | db_person.id | Requestor Requestor ID | ||
| requestor_name | StringString | Requestor Requestor name (in case requestor is not a user of the system) | |||
| requestor_email | StringString | Requestor Requestor email (in case requestor is not a user of the system) | |||
| creator_id | IntegerInteger | db_person.id | Creator Creator ID | ||
| assigned_to_id | IntegerInteger | db_person.id | Current Current owner | ||
| state_id | IntegerInteger | db_state.id | StateState this process is in | ||
| completed | DateDate | Completed | Completed on | ||
| followers_csv | String | Person ID CSV (-1 means project team), (-2 means PM) | |||
| is_requestor_visible | BooleanBoolean (t or f) | Is | 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 |