# SYS_LOG: Audit Trail (system) - Name: `SYS_LOG` - Catalog: `AccountView` - Label: Audit Trail (system) - Partition-specific: true - Select: true - Insert: false - Update: false - Delete: false ## Table Columns The columns of the table `SYS_LOG` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `ADM_CODE` | `string(10)` | Administration code | ☐ | | | `CNG_ID` | `string(10)` | Unique change code | ☐ | | | `COMP_NAME` | `string(20)` | Workstation | ☐ | | | `LOG_BIN` | `string(4)` | Field, old value, new value | ☐ | | | `LOG_DATE` | `datetime` | Date/time | ☐ | | | `LOG_TYPE` | `string(15)` | Log type | ☐ | | | `partition_code` | `string` | Partition code | ☑ | | | `partition_name` | `string` | Partition name | ☑ | | | `PKEY_VALUE` | `string(40)` | Key field value | ☐ | | | `REC_ID` | `string(10)` | Unique code | ☐ | | | `TBL_NAME` | `string(12)` | Table name | ☐ | | | `USR_ID` | `string(20)` | User name | ☐ | |