POLICYTC

This table stores information about which business policy is referenced by a specific term or condition.

Column Descriptions:

NameTypeDescription
TERMCOND_IDBIGINT NOT NULLThe terms and conditions ID.
POLICY_IDBIGINT NOT NULLThe policy ID.
OPTCOUNTERSMALLINT NOT NULL DEFAULT 0The optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.

Indexes:

NameColumn NamesType
<SYSTEM-GENERATED>POLICY_ID+TERMCOND_IDPrimary Key
I0000357TERMCOND_ID+POLICY_IDNon-Unique Index
I0001273POLICY_IDNon-Unique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_613POLICY_IDPOLICYPOLICY_IDCascade
F_614TERMCOND_IDTERMCONDTERMCOND_IDCascade