Retention Period Definition for Retention Policy Changes
Retention Period Definition for Retention Policy Changes
When you change the retention policy assigned to records in an entity, you must define a new retention period for the records you want to update. Define the new retention period when you modify the assigned retention policy in Data Discovery.
To define the new retention period, select the new retention policy and enter rules that determine which date Data Archive uses to calculate the expiration date for records. The expiration date for records equals the retention period plus the date value that is determined by the rules you enter.
You can enter the following types of rules:
Relative Date Rule
Bases the retention period for records on a fixed date. For example, you select a retention policy that has a 10 year retention period. You enter January 1, 2011, as the relative date. The new expiration date is January 1, 2021.
Column Level Rule
Bases the retention period for records on a column date. For example, you select a retention policy that has a five year retention period. You base the retention period on the CLAIM_DATE column. Records expire five years after the claim date.
Expression-Based Rule
Bases the retention period for records on the date returned by an expression. For example, you select a retention policy that has a five year retention period. You want to base the retention period on dates in the CLAIM_DATE column, but the column contains integer values. You enter the expression
TO_DATE(CLAIM_DATE,'ddmmyyyy')
. Records expire five years after the claim date.
The rules you enter must evaluate to a single date value or to a column date. If you enter multiple rules, you cannot select a relative date. You must select the maximum date or the minimum date across all rules.
For example, you have a five-year retention policy for insurance records that retires records five years after the last transaction date. You want to select the last transaction date from three tables and apply the new retention policy using that date.
The following entity tables contain the last transaction date:
Policy.LAST_TRANS
Messages.LAST_TRANS_DATE
Claims.LAST_DATE
To select the last transaction date across tables, complete the following tasks:
Select the five-year retention policy as the new retention policy.
In the
Base Retention Period On
area, add a row for each column:
Entity Table
Retention Column
Policy
LAST_TRANS
Messages
LAST_TRANS_DATE
Claims
LAST_DATE
In the
By evaluating the
list, select
Maximum
.
When you update the retention policy, you can select a checkbox to generate a retention modification report that is accessible from the
Monitor Jobs
page. You can also select a checkbox to include the reference tables in the retention update.