api_project_service_hour_budgets
⚠️ Important: Some fields in this table will be deprecated on Wednesday, January 7th, 2025. Please review the Deprecated Fields section below and migrate to the recommended alternatives.
This table provides hour budget data for project services from Simplicate.
Description
The api_project_service_hour_budgets table exposes hour budget information configured for project services, broken
down by item type.
Fields
| Field Name | Type | Description |
|---|---|---|
project_id | Integer | Identifier of the project (composite key) |
project_service_id | Integer | Identifier of the project service (composite key) |
item_type_id | Integer | Identifier of the item type (hour type) (composite key) |
budget_hours | Numeric | Total budgeted hours for this service and item type |
budget_value | Numeric | Total budgeted monetary value for this service and item type |
Deprecated Fields
⚠️ Deprecation Notice: The following fields will be deprecated on Wednesday, January 7th, 2025. Please migrate to the recommended alternatives.
| Deprecated Field | Type | Recommended Alternative |
|---|---|---|
key_project_id | Integer | project_id |
key_project_service_id | Integer | project_service_id |
key_item_type_id | Integer | item_type_id |
Related Tables
api_projects- Project details viaproject_idapi_project_services- Service details viaproject_service_idapi_item_types- Item type details viaitem_type_id