Contains the value information for the closed item for each additional field
Data model
Fields
| Field | Type | Description |
|---|---|---|
| bool_value | BIT | Value of the additional field stored as boolean |
| date_value | DATETIME | Value of the additional field stored as a date |
| field_catalog_id | INT | Identifier of the associated catalog (if it is a catalog type field), reference the table AFW_CATALOG.cata_id |
| field_id* | INT | Identifier of the associated additional field, reference the ASMS_FIELDS.id table |
| field_name | NVARCHAR (100) | Name of the additional field |
| field_order | INT | Describes the order in which the additional field is displayed |
| field_type_id | INT | Field type identifier (Combo, Date, Text, Checkbox, Long Text, Numeric Text, etc.) |
| float_value | FLOAT | Value of the additional field stored as a floating number |
| int_value | INT | Value of the additional field stored as an integer |
| item_id* | INT | Identifier of the associated item |
| item_type_id* | INT | Identifier of the type of item (Incident, Change, Problem, Requirement, Request among others), reference the table ASMS_TYPES.id |
| string_value | NVARCHAR (8000) | Value of the additional field stored as a text string |
Primary Key
| PK_ASMS_FIELDS_DATA_CLOSED |
|---|
| item_id, field_id, item_type_id |