Default Work Queue

Configuration for automatically assigning work queues is stored in the DAMAGE_REPAIR_TIMES table. When damage assessment is created or updated trouble queues will be determined based on damaged asset and added to the event(s) associated with the damaged assessment.

Examples

Non-modeled damaged asset - tree. Assigned to work queue TRE.

INSERT INTO damage_repair_times (asset_type, repair_time_a,
repair_time_i, default_tq)

VALUES ('40', 120, 120, 'TRE');

Device classes for modeled assets. Damaged lines assigned to work queue LNE.

INSERT INTO damage_repair_times (asset_type, repair_time_a,
repair_time_i)

VALUES ('transformer', 180, 300);

INSERT INTO damage_repair_times (asset_type, repair_time_a,

repair_time_i)

VALUES ('_fuse', 30, 30);

INSERT INTO damage_repair_times (asset_type, repair_time_a,

repair_time_i)

VALUES ('wood_pole', 90, 180);

INSERT INTO damage_repair_times (asset_type, repair_time_a,

repair_time_i, default_tq)

VALUES ('_electric_line_seg', 0, 0, 'LNE');