Damaged Asset Status Options

The possible values for the damaged asset status drop-down list are configured in the MESSAGE_CODE_LOOKUP database table. MESSAGE_TOPIC is 'DA_ASSET_STATUS'. Drop-down list items are sorted according to the values in the MESSAGE_ORDER column.

The MESSAGE_CODE 'OPEN' is used to indicate that the damaged device is open and customers are without power.

Example

INSERT INTO message_code_lookup (message_topic, message_code,

message_string, message_order)

VALUES ('DA_ASSET_STATUS', 'NA', 'N/A', 1);

INSERT INTO message_code_lookup (message_topic, message_code,

message_string, message_order)

VALUES ('DA_ASSET_STATUS', 'OPEN', 'Open', 2);

INSERT INTO message_code_lookup (message_topic, message_code,

message_string, message_order)

VALUES ('DA_ASSET_STATUS', 'CLOSED', 'Closed', 3);