EN
Español
English
Português
    APMO_WORKFLOW

    Module workflows (states and transitions by entity type), with versioning and publishing status

    Data model

    Fields

    Field Type Description
    entity_type* VARCHAR (50) Type of entity to which you apply the workflow (e.g. WorkItem)
    is_active* BIT Logical Deletion: 1 = Active Record, 0 = Retired
    is_default* BIT Indicates if it is the default workflow for the entity type
    methodology_id UNIQUEIDENTIFIER Methodology associated with the workflow (NULL = applies to all)
    publish_status* VARCHAR (30) Workflow Publishing Status (Draft or Published)
    workflow_id* UNIQUEIDENTIFIER Unique workflow identifier
    workflow_name* VARCHAR (150) Workflow name
    workflow_version* VARCHAR (30) Workflow version

    Primary Key

    PK_APMO_WORKFLOW
    workflow_id

    References

    Column Referenced Table Referenced column Name
    methodology_id dbo.APMO_METHODOLOGY methodology_id FK01_APMO_WORKFLOW