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 |