Contains information from closed historical service categories for ASMS
Data model
Fields
| Field | Type | Description |
|---|---|---|
| ctg_caption | NVARCHAR (200) | Name of the closed category |
| ctg_index* | INT | Unique identifier of the closed category |
| ctg_parent | INT | Identifier of the parent category from which this closed category record inherits in a hierarchical structure, reference the table ASDK_CATEGORY.ctg_index |
| ctg_service_id | INT | Identifier of the service to which the category was related |
| fl_int_status_id | INT | Status identifier related to the category |
| fl_str_description | NVARCHAR (MAX) | Additional description of the closed category |
| fl_str_hierarchy | NVARCHAR (4000) | Positional long name of the closed category in a hierarchical structure |
| is_visible_user* | BIT | Identifies whether the category is visible to the user (0 = not visible, 1 = visible) |
Primary Key
| PK_ASDK_CATEGORY_CLOSED |
|---|
| ctg_index |