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.
  • By default, the values in the CA_LOG are all raw values except enumeration values.
  • To log EU converted values for point_val and point_prevval fields of CA_LOG,
    1. Enable device conversion. For information refer, Step 3.2. Configure the Conversion Type for a Device Point.
    2. Add the parameter PTMRP_CALOG_EU_VALUES to project parameters and set its value to Y.
  • Enumerated points log their configured values, e.g. Closed not 0.