db_company
- Former user (Deleted)
- Rashmi Likhite
- Former user (Deleted)
Owned by Former user (Deleted)
Stores organization related information. Every record corresponds to an organization.
| Column | Type | References | Comments |
|---|---|---|---|
| id | Integer | Â | Primary key |
| guid | String | Â | Â |
| vdb_id | Integer | Â | Â |
| name | String | Â | The name of the company |
| campaign | String | Â | Â |
| gclid | String | Â | Â |
| referrer | String | Â | Â |
| currency_symbol | String | Â | Â |
| contact_name | String | Â | Â |
| contact_email | String | Â | Â |
| country | String | Â | Â |
| server_name | String | Â | Â |
| industry | String | Â | Â |
| created | Date | Â | Â |
| fl | Integer | Â | Â |
| document_fo_id | Integer | db_folder.id | ID of the document folder |
| project_owner_gid | Integer | db_group.id | ID of the project manager dynamic security role |
| project_team_gid | Integer | db_group.id | ID of the project team member dynamic security role |
| task_team_gid | Integer | Â | ID of the task team member dynamic security role |
| staff_gid | Integer | db_group.id | ID of the staff security role (db_group) |
| company_code | String | Â | The company code. This should be used while logging in to the API |
| locale_id | String | Â | Â |
| time_zone_id | String | Â | The default time zone of the organization |
| te_on_cp | Boolean (t or f) | Â | Indicates whether time can be filled on archived project |
| te_on_any | Boolean (t or f) | Â | Allow time on any task |
| te_auto_approve | Integer | Â | Auto approve time |
| te_is_hours_in_decimal | Boolean (t or f) | Â | Is Time entered in decimals |
| te_billing_model | Integer | Â | Â |
| te_remind_at | String | Â | Â |
| te_limit_allocated | Boolean (t or f) | Â | Â |
| all_in_alloc | Boolean (t or f) | Â | Show all users during allocation of tasks to resources (true) or just the project team members (false) |
| allow_users_wte | Boolean (t or f) | Â | Allow users to specify whether they are working (true)/non-working (false) when entering calendar events. If true, exceptions will immediately impact scheduling. |
| process_client_user_visibility | Integer | Â | Does the client see only the PM (1) or all users (0) |
| first_day_of_week | Integer | Â | The first day of the week in calendar. 1 for Sunday, 2 for Monday, 3 for Tuesday, etc. |
| min_days_in_first_week | Integer | Â | The minimum number of days in the first week |
| minutes_in_day | Integer | Â | Minutes in day. This is used for scheduling. Default is 8 hours i.e. 480. |
| task_start_before | Integer | Â | The number of hours to start the task before |
| task_with_time | Boolean (t or f) | Â | Whether to show time in task start and finish |
| affiliate_unique_id | String | Â | Â |
| load_optimal_low | Float | Â | Â |
| load_optimal_high | Float | Â | Â |