EN
Español
English
Português
    APMO_CAPACITY_PLAN

    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

    Column Referenced Table Referenced column Name
    project_id dbo.APMO_PROJECT project_id FK02_APMO_CAPACITY_PLAN
    resource_id* dbo.APMO_RESOURCE resource_id FK01_APMO_CAPACITY_PLAN
    sprint_id dbo.APMO_SPRINT sprint_id FK03_APMO_CAPACITY_PLAN