WORKITEMLC Entries - Database Reporting Guide - Foundation 23.1 - Foundation 23.1 - Ready - OnBase - external

Database Reporting Guide

Database Reporting Guide
Foundation 23.1

If the deleted Work Item is in any Unity Life Cycles, on deletion any WORKITEMLC table entries for the Work Item are moved to another table, WORKITEMLCUNAVAIL. If the Work Item is subsequently undeleted, any WORKITEMLCUNAVAIL entries are moved back to WORKITEMLC.

Note: The reason that for the changed behavior is because the presence of a large number of entries for deleted but not purged documents in ITEMLC could skew the database statistics and lead to a performance degradation. By using a separate table, only active items contribute to the statistics.