SystemNote2
Serves as an extended logging mechanism for tracking changes made to records, providing detailed audit trails.
Columns
| Name | Type | References | Description |
| actor | String | The user or system that made changes to the object or value. | |
| context | String | The environment or purpose associated with the modification (for example, user interface or script). | |
| datefrom | Date | The starting date for the period or range considered. | |
| dateto | Date | The ending date for the period or range considered. | |
| elementfullname | String | The complete name of the element being modified or referenced. | |
| instancename | String | The name of the object being modified or referenced. | |
| locale | String | The regional or language settings associated with the object or change. | |
| objectactiontype | String | The type of action performed on the object (for example, create, update, or delete). | |
| objectelementkey | Integer | A unique identifier for the element being modified within the object. | |
| objectelementname | String | The name of the element being modified within the object. | |
| objectid | Integer | The unique identifier for the object being modified or referenced. | |
| objectparent | Integer | The unique identifier of the parent object. | |
| objectroot | Integer | The unique identifier of the root object in the hierarchy. | |
| role | Integer | The numeric identifier of the user role associated with the modification. | |
| rolename | String | The name of the user role associated with the modification. | |
| rootinstancename | String | The name of the root object in the hierarchy. | |
| rootobjectbkey1 | Boolean | This key represents a Boolean indicator associated with a root object. | |
| rootobjectbkey2 | Boolean | This key represents an additional Boolean indicator associated with a root object. | |
| rootobjectdkey1 | Date | This key represents a date value related to a root object. | |
| rootobjectelementkey | Integer | A unique identifier associated with an element within the root object. This key is used for linking or referencing specific components within a larger structure. | |
| rootobjectelementname | String | The name of the element within the root object. It serves as a descriptive label or identifier to differentiate components. | |
| rootobjectnkey1 | Integer | A numeric key associated with the root object. Often used for storing quantitative values such as counts, indexes, or IDs. | |
| rootobjectnkey2 | Integer | An additional numeric key associated with the root object. Typically used for storing secondary numeric data relevant to the root object. | |
| rootobjectnkey3 | Integer | Another numeric key associated with the root object. It may be used to represent various numeric attributes or metrics related to the object. | |
| rootobjectnkey4 | Integer | A fourth numeric key associated with the root object. This key can be used for specialized numerical data storage or calculations. | |
| rootobjectskey1 | String | A string key associated with the root object. This key may contain textual information relevant to the object's context or description. | |
| rootobjectskey3 | String | An additional string key associated with the root object, often used for supplementary text-based attributes or metadata. | |
| runid | Integer | The identifier for the specific execution or process run. | |
| timestamputc | Date | The date and time when the modification was applied. | |
| valueactiontype | String | The type of action applied to the value (for example, added, modified, or removed). | |
| valuedatatype | String | The data type of the modified value (for example, string, integer, or Boolean). | |
| valueelementkey | Integer | A unique identifier for the value element being modified. | |
| valuenewboolean | Boolean | The new Boolean value applied to the object. | |
| valuenewdate | Date | The new date value applied to the object. | |
| valuenewdisplayname | String | The new display name or text applied to the object. | |
| valuenewnumber | Decimal | The new numeric value applied to the object. | |
| valuenewreference | Integer | The primary reference to a related object or value. | |
| valuenewreference2 | Integer | The secondary reference to a related object or value. | |
| valuenewstring | String | The new text or string value applied to the object. | |
| valueoldboolean | Boolean | The previous Boolean value before modification. | |
| valueolddate | Date | The previous date value before modification. | |
| valueolddisplayname | String | The previous display name or text before modification. | |
| valueoldnumber | Decimal | The previous numeric value before modification. | |
| valueoldreference | Integer | The previous primary reference to a related object or value. | |
| valueoldreference2 | Integer | The previous secondary reference to a related object or value. | |
| valueoldstring | String | The previous text or string value before modification. |