Retention Policy Editor

Retention policies are used to delete or purge data. Reasons to delete data may include:

  • Compliance with state or federal laws such as the Family Educational Rights and Privacy Act (FERPA)
  • Adherence to institutional retention policies developed in conjunction with the institution’s general counsel
  • Batch deletion of data erroneously imported using Upload Dataset

By default, Slate retains all data in perpetuity. Retention policies must be created to purge specific data at the appropriate times.

Important

Use with caution. Retention policies will permanently delete selected data. Once a retention policy is executed, there is no way for the institution or Technolutions to recover deleted data.
Developing Retention Policies

Before configuring retention policies in Slate, it is strongly advised to consult and collaborate with additional stakeholders to ensure that legal and institutional guidelines are being followed, specifically as they relate to FERPA and other state and federal laws. Stakeholders may include:

  • General Counsel
  • Institutional Research
  • Registrar
  • IT
  • Financial Aid

Consider creating one or more test records that contain data in each retention policy item. This will allow for easier testing later in the process and will ensure that the data is being deleted as intended.

Configuring Retention Policies

Retention policies are composed of groups and individual policies. Retention groups are collections of policies that are executed together in a specified order. For example, an application record must be deleted before a person record, or application records within a round must be deleted before the round can be deleted.

Groups enable partners to organize policies to execute the deletion of like data. Depending on the specificity of the kinds of data to be deleted, a comprehensive retention group could include several or even dozens of retention policies. Each policy must be configured individually. All retention policies are built on the configurable join query bases. Being able to query using configurable joins is essential to creating and executing successful retention policies.

Specific permissions grant users access to retention policies:

Permission Description
Retention Policy Editor Grants a user access to the Retention Policies tool in the database.
Retention Policy Editor – Edit All Grants a user the ability to create and edit retention policies.
Retention Policy Editor – Execute All Grants a user the ability to execute retention policies

 Tip

Retention policies can be configured and executed in both production and test environments.

Creating Retention Groups

Create retention groups to develop retention policies.

  1. Select Database on the top navigation bar and select Retention Policies.
  2. Select New Group.
  3. Enter the following configurations in the dialog box:
    • Name: Give the retention group a descriptive name.
    • Status: Set the status to Active to be able to execute policies within the group.
    • Folder: Assign the group to a folder.
  4. Select Save.

Creating a Retention Policy

After a retention group is created, create individual retention policies to be executed within the group.

  1. Select the desired retention group where the retention policy should reside.
  2. Select New Policy.
  3. Enter the following configurations in the dialog box:
    • Name: Give the retention policy a descriptive name.
    • Object Type: Select the type of data to be deleted.
    • Base: Choose the base. This is the configurable join base on which the policy will be filtered to identify the data to be deleted.
    • Order: Give the policy a distinct order. Policies within the group will be executed sequentially according to the order.
    • Stop Threshold: Set the stop threshold (for example, 500, 1000, or 5000).
  4. Select Save.

Important

The status on a retention policy defaults to Inactive when it is created. Update the status to Active after it is saved to be able to execute the policy within the group. All policies within the group are executed together.

  What does the stop threshold do?

If the stop threshold is exceeded, the retention policy will not run and the execution of policies within the retention group will stop as well. Your stop threshold should be greater than or equal to the number of records being returned in your retention policy.

Executing Retention Policies

Before executing retention policies, make sure that the retention group and desired retention policies are set to Active.

  1. Select Database on top navigation bar and select Retention Policies.
  2. Select the desired retention group for execution.
  3. Select Execute.
  4. Add a memo in the dialog box and select Execute again.

Scheduling Retention Policies

The execution of retention policies can be automated by scheduling the policies to run overnight.

  1. Select Database on the top navigation bar and select Retention Policies.
  2. Select the desired retention group for scheduling.
  3. Select Run Options. A dialog box opens.
  4. Select Enable Scheduled Policy Run.
  5. Select the days on which the policy should execute.
  6. Select Save.

Active policies within the retention group will be executed during the next overnight processing window following the day selected (for example, If Tuesday is selected, the policies will be executed overnight from Tuesday into Wednesday).

Executing Retention Policies on a Single Record

Retention policies can be executed on individual records administratively. The retention group must first be enabled for record-specific run.

  1. Select Database on the top navigation bar and select Retention Policies.
  2. Select the desired retention group.
  3. Select Run Options. A dialog box opens.
  4. Select Enable Record-Specific Run for Users with Update Permissions.
  5. If desired, set a population restriction. The retention group can only be executed administratively on records enrolled in the selected populations.
  6. Select Save.

Once enabled, policies within the retention group can be run on any person, application, or dataset record.

  1. Go to the desired record in the database.
  2. Select the Profile tab.
  3. Select Account.
  4. Select Execute Policy. A dialog box opens.
  5. Enter the following configurations:
    • Policy Group: Select the retention group to be executed on the record.
    • Memo: Add a memo.
  6. Select Execute.
Was this article helpful?
15 out of 45 found this helpful