[dbo]​.[writeSimpleObjectEvent] stored procedure

@objectId

Y

T_nameType, nvarchar(32)

The ID number associated with the object.

@time

N

T_GMTtime, int

The time in seconds from Jan 1, 1970 in Greenwich Mean Time (GMT). If the @time is not provided, the current time is used.

@deviceOffset

N

T_GMToffset, smallint

The device timezone represented in minutes from GMT. For example, Mountain Standard timezone is -420. Mountain Daylight timezone is -360. It is calculated based on the time of the data and the timezone of the device. If the @deviceOffset is not provided, the field timezone of the meter or gas quality is used to calculate the offset.

@eventType

Y

T_nameType, nvarchar(32)

The type of event. The value will be checked against the column eventTypeName in the eventTypeDesc table. If the eventTypeName is not found, the event data will be rejected.

@message

Y

T_messageType, nvarchar(255)

The message describing the event.

@userName

Y

T_nameType, nvarchar(32)

The name of the user or system that made the submission.

@eventSeverityName

N

T_nameType, nvarchar(32)

The severity of the event. The value will be checked against the column eventSeverityName in the eventSeverityDesc table. If the eventSeverityName is not found, the event data will be rejected. If the @eventSeverityName is not provided, it will default to Normal.

@newValue

N

T_doublePrecisionType, float

Used for alarms and events sent by external systems. The updated numeric value after an event or alarm occurred.

@oldValue

N

T_doublePrecisionType, float

Used for alarms and events sent by external systems. The original numeric value before an event or alarm occurred.

@newValueText

N

T_descType, nvarchar(128)

Used for alarms and events sent by external systems. The updated string value after an event or alarm occurred.

@oldValueText

N

T_descType, nvarchar(128)

Used for alarms and events sent by external systems. The original string value before an event or alarm occurred.

@eventCodeDescription

N

T_descType, nvarchar(128)

Used for alarms and events sent by external systems. A description of what type of alarm or event was triggered. Most are self-explanatory and match whatever problematic data was sent (for example, "Temperature" or "BasePressure"). Some other sample general code descriptions:

• "General Event"

• "Invalid Value"

• "Unknown Value"