3. Change Approval: CA_LOG
Details about all attempts to perform a setpoint on points that require validation are entered into a CA_LOG table in SQL Server.
- Data: Entered in CA_LOG.
- Guidelines: CA_LOG review.
Data: Entered in CA_LOG
The following data is entered in the CA_LOG.
Field | Max. Length | Description |
---|---|---|
timestamp | 7 | Local time |
timestamp_utc | 7 | UTC time |
sequence_number | - | Sequence of setpoint action |
project | 20 | Project in which the point was located. |
logged_by | 32 | Logged in user |
performby_userid | 32 | User who entered the setpoint. |
performby_comment | 80 | Performer's comment. |
verifyby_userid | 32 | User who verified the setpoint. |
verifyby_comment | 80 | Verifier's comment. |
location | 32 | Name of the computer from which the change was made. |
action | 32 | Type of action performed, e.g. SETPOINT, ALARMACK, ALARMDEL, DYNCFG. |
result | 10 | SUCCESS, FAILURE |
message | 80 | Result description, e.g. SETPOINT SUCCESS, INVALID PERFORM USERID. |
point_id | 256 | Point that was set. |
point_attribute | 26 | Name of the attribute on which a setpoint was performed. |
point_val | 255 | Value that point was set to. |
point_prevval | 255 | Point value before it was changed. |
alarm_id | 256 | Generated alarm ID. |
alarmmessage | 512 | Generated alarm message. |
Guidelines: CA_LOG Review
- If an array point requires change approval, even if a setpoint is performed on any index in the array, the CA_LOG will log the first index information only.
- Values in the CA_LOG are all raw values except enumeration values.
- Enumerated points log their configured values, e.g. Closed not 0.