EN
Español
English
Português
    APMO_CATALOG_MAP

    Module Catalog Map: Associates the GUID saved by the module columns (module_guid) with the ASMS core AFW_CATALOG_CODE code_id (without physical KK)

    Data model

    Fields

    Field Type Description
    catalog_code_id* INT Core catalog value (AFW_CATALOG_CODE.code_id; no physical KK)
    catalog_map_id* UNIQUEIDENTIFIER Unique identifier of the mapping
    catalog_type* VARCHAR (40) Backend Internal Catalog Type (Priority, ProjectStatus, WorkItemStatus, SprintStatus, WorkItemType, RelationType, ResourceRole, Seniority, AbsenceType)
    is_active* BIT Logical Deletion: 1 = Active Record, 0 = Retired
    module_guid* UNIQUEIDENTIFIER GUIDs that save module columns for catalog value

    Primary Key

    PK_APMO_CATALOG_MAP
    catalog_map_id