You can create and change retention policies if you have the retention administrator role. You can create retention policies in the workbench and when you create a retirement archive project.
If you create retention policies in the workbench, you can use them in data archive projects that archive data to the Data Vault. You can also use the policies in retirement archive projects. If you create retention policies when you create a retirement archive project, Data Archive saves the policies so that you can use them in other archive projects
After you create retention policies, you can use them in archive projects. When you run the archive job, Data Archive assigns the retention policies to entities and updates the expiration dates for records. You can change the retention periods for archived records through Data Discovery. Change the retention period when a corporate retention policy changes, or when you need to update the expiration date for a subset of records. For example, an archive job sets the expiration date for records in the ORDERS table to five years after the order date. If an order record originates from a particular customer, the record must expire five years after the order date or the last shipment date, whichever is greatest.
To use an entity in a retention policy, ensure that the following conditions are met:
The entity must have a driving table.
The driving table must have at least one physical or logical primary key defined.
To create and apply retention policies, you might complete the following tasks:
Create one or more retention policies in the workbench that include a retention period.
If you want to base the retention period for records on a column date or an expression, associate the policies to entities.
Create an archive project and select the entities and retention policies. You can associate one retention policy to each entity.
Run the archive job.
Data Archive assigns the retention policies to entities in the archive project. It sets the expiration date for all records in the project.
Optionally, change the retention policy for specific archived records through Data Discovery and run the Update Retention Policy job.
Data Archive updates the expiration date for the archived records.
Run the Purge Expired Records job.
Data Archive purges expired records from the Data Vault.
If you have the retention viewer role, you cannot create, edit, or assign retention policies. You can perform Data Discovery searches based on retention policy and retention expiration date, and you can view the policy details and the table data. For more information on the differences between the retention administrator and the retention viewer roles, see the