If logging is enabled for one or more registered change notifications, records will be produced in the CN_Log repository for each attribute that has changed (or is designated to be displayed alongside a change).
The following table provides detailed information about each attribute in this repository.
| Attribute Name | Description |
|---|---|
| CN_Action |
Type of action:
|
| CN_Attribute_Language | Identifies the language for which the change was made if the attribute is multi-language, otherwise blank. |
| CN_Attribute_Name | Name of the attribute that was modified, or specified to be logged always or derived from an external repository. |
| CN_Change_ID | Sequential ID of a specific change. If more than one monitored/logged attribute was changed, all will share the same change ID. |
| CN_Changed_By | Login name of the user who initiated the change. |
| CN_Changed_Datetime | Date and time of when the change was made. |
| CN_Internal_Record_ID | Internal ID of the record that was changed. This value can be used when performing SQL queries to retrieve current data from the record. |
| CN_Log_ID | Unique ID for each CN_Log record. |
| CN_New_Value | The current or new value for the attribute (at the time of the change). |
| CN_Old_Value | The previous value for the attribute. For "allways log"attributes that have not changed as well as external attributes, the old and new values will be the same. |
| CN_PK1, CN_PK2, CN_PK3, CN_PK4, CN_PK5 | Primary key for the modified record. The number of key fields defined depends on the repository. Many repositories will only have a value in the first key field. |
| CN_Registry_ID | ID of the CN_Registry record that was used to log the change. |
| CN_Repository_ID | Internal ID of the repository in which the record was changed. |
| CN_Repository_Name | Name of the repository in which the record was changed. |