Describes an app itema 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 app item 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 app item 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 | app itemprocess 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? | custom_field_string | String | (New column since v9.1) Includes a JSON formatted string of all custom fields attached to this entity | |
| 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 |