Configurable capacity calculation rules and thresholds (a single active row, guaranteed by the UX01_APMO_CAPACITY_RULES filtered single index)
Data model
Fields
| Field | Type | Description |
|---|---|---|
| alert_pmo_on_overload* | BIT | Indicates whether the PMO is alerted to resource overload |
| capacity_rules_id* | UNIQUEIDENTIFIER | Unique identifier for capacity rules |
| consolidate_across_projects* | BIT | Indicates whether the load is consolidated between projects |
| discount_holidays* | BIT | Indicates whether holidays are deducted from capacity |
| green_threshold* | DECIMAL | Green traffic light threshold (load percentage) |
| is_active* | BIT | Logical deletion: 1 = active (unique) rules, 0 = withdrawals |
| validate_before_sprint* | BIT | Indicates whether capacity is validated before triggering a sprint |
| yellow_threshold* | DECIMAL | Yellow traffic light threshold (load percentage); above it is red |
Primary Key
| PK_APMO_CAPACITY_RULES |
|---|
| capacity_rules_id |