What does a lookup column with a value of -3 in Caboodle imply?

A lookup column with a value of -3 in Caboodle signifies that the row represents deleted data from the source. Additionally, it also indicates that the row is treated as a primary key for the lookup, signifying that it is an existing entry in the dataset even though it has been marked as deleted. This dual implication allows the system to maintain a complete historical record of data, which is essential for auditing and understanding data lineage.

In the context of data management and modeling, accurately tracking deleted records is crucial for maintaining data integrity and ensuring that historical analyses can be performed effectively. By using a lookup value of -3, Caboodle can seamlessly differentiate between actively used rows and those that have been marked for deletion while still retaining their significance within the database structure.