Capacity plan by resource and date (available/planned/executed hours, load percentage and traffic light), optionally associated with project and sprint
Data model

Fields
| Field |
Type |
Description |
| available_hours* |
DECIMAL |
Available Resource Hours on Date |
| capacity_date* |
DATE |
Capacity Plan Date |
| capacity_plan_id* |
UNIQUEIDENTIFIER |
Unique Capacity Plan Identifier |
| capacity_status |
VARCHAR (20) |
Traffic light capacity (Green, Yellow, Red) |
| executed_hours |
DECIMAL |
Hours Executed Recorded |
| is_active* |
BIT |
Logical Deletion: 1 = Active Record, 0 = Retired |
| load_percent |
DECIMAL |
Resource load percentage |
| overload_percent |
DECIMAL |
Resource overhead percentage |
| planned_hours* |
DECIMAL |
Resource’s Planned Hours on Date |
| project_id |
UNIQUEIDENTIFIER |
Project associated with the plan (optional) |
| remaining_hours |
DECIMAL |
Remaining Plan Hours |
| resource_id* |
UNIQUEIDENTIFIER |
Resource to which the plan applies |
| sprint_id |
UNIQUEIDENTIFIER |
Sprint associated with the plan (optional) |
Primary Key
| PK_APMO_CAPACITY_PLAN |
| capacity_plan_id |
References