WORKITEMLC Entries - Database Reporting Guide - English - Foundation 22.1 - OnBase - external

Database Reporting Guide

Platform
OnBase
Product
Database Reporting Guide
Release
Foundation 22.1
License

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.