Describes a app itemprocess
| 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 |