When you configure column level retention, each record in an entity has a unique expiration date. For example, you create a retention policy with a 10 year retention period and associate it to entity EMPLOYEE, table EMP, and column TERM_DATE. In a data archive project, you select this policy for the EMPLOYEE entity. Each record in the EMPLOYEE entity expires 10 years after the date in the EMP.TERM_DATE column.

You can configure column level retention in the workbench when you manage retention policies or when you change retention policies for archived records in Data Discovery. You can also configure column level retention when you select entities in a data archive project or a retirement archive project. Select the entity, and then select the retention policy. The retention policy list appends the table and column name to the names of retention policies with column level associations. You cannot configure column level retention for retention policies with indefinite retention periods.