EN
Español
English
Português
    APMO_WORK_ITEM

    Hierarchical backlog work items (Epic, Feature, UserStory, Task, Bug) with parent auto-reference

    Data model

    Fields

    Field Type Description
    acceptance_criteria NVARCHAR (MAX) Work item acceptance criteria
    assigned_to INT ASMS user assigned (AFW_USERS.user_id, no physical FK to core)
    backlog_order* INT Order of the item within the backlog
    block_reason NVARCHAR (MAX) Reason for the block
    business_value INT Business value of the work item
    description NVARCHAR (MAX) Detailed description of the work item
    due_date DATE Work item commitment date
    estimated_hours* DECIMAL Estimated hours (0 = unestimated)
    is_active* BIT Logical Deletion: 1 = Active Record, 0 = Retired
    is_blocked* BIT Indicates if the item is locked
    parent_work_item_id UNIQUEIDENTIFIER Parent Work Item in Hierarchy (NULL = root level)
    priority_id* UNIQUEIDENTIFIER Work item priority (module catalog GUID, type Priority)
    project_id* UNIQUEIDENTIFIER Project to which the work item belongs
    remaining_hours DECIMAL Hours remaining to complete the item
    start_date DATE Planned start date (Gantt view)
    status_id* UNIQUEIDENTIFIER Work item status (module catalog GUID, type WorkItemStatus)
    story_points INT Estimated Story Points
    title* VARCHAR (300) Title of the work item
    work_item_code* VARCHAR (50) Unique work item code
    work_item_id* UNIQUEIDENTIFIER Unique identifier of the work item
    work_item_type_id* VARCHAR (20) Canonical type of the work item: Epic, Feature, UserStory, Task, or Bug

    Primary Key

    PK_APMO_WORK_ITEM
    work_item_id

    References

    Column Referenced Table Referenced column Name
    parent_work_item_id dbo.APMO_WORK_ITEM work_item_id FK02_APMO_WORK_ITEM
    project_id* dbo.APMO_PROJECT project_id FK01_APMO_WORK_ITEM