Stores resources, contacts, clients and usersDescribes a process
| Column | Type | References | Comments | ||||
| id | Integer | Primary key | |||||
| vdb_idguid | IntegerString | guid | |||||
| vdb_id | StringInteger | ||||||
| created | Date | Date created | |||||
| namesummary | String | Name of the user | login_nameShort summary | ||||
| detail | String | Login name | pwd | StringDetailed description | |||
| due_date | Date | Encrypted | passwordDue date | ||||
| pwdis_changed_at | Date | ||||||
| phone | String | ||||||
| String | Email Address | ||||||
| keywords | String | Keywords related to this user e.g. skills, qualifications | |||||
| archived | Date | Date on which this user was archived | |||||
| discriminator | Integer | 4 = contact, 24 = user, 63 = client | |||||
| folderdelayed | 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_folderperson.id | Requestor ID of the personal document folder of this user | is_public | Boolean (t or f) | Is this record viewable by anyone in the company | |
| 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 IdID | ||||
| inassigned_outto_statusid | String | in_out_updated_onInteger | db_person.id | Current owner | |||
| state_id | Integer | db_state.id | State this process is in | ||||
| completed | Date | Completed on | |||||
| subscribers_csv | String | Person ID CSV (-1 means project team), (-2 means PM) | |||||
| is_requestor_invisible | Boolean (t or f) | Is visible to requestor? | |||||
| my_b_time_money | Float | If this user is in or out | |||||
| last_access | Date | The last time the user accessed the system | |||||
| parent_id | Integer | The parent of this record. In case of client this is the ID of the parent. | |||||
| path | String | Path separated by '/' from root user object. | |||||
| locale_id | String | ||||||
| time_zone_id | String | Time zone ID of this user | |||||
| calendar_id | Integer | db_working_calendar.id | The working calendar of this userTotal 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 |