What Data Is Purged?

Tables Tab | Units (Event Based) Tab | Variables (Time Based) Tab

Tables Tab

When you purge data for specific tables, all the data older than the retention period in the table are purged.

Tables tab

Select...

Data purged from...

Active_Specs

  • Active_Specs: By expiration date (comments not deleted)

  • Var_Specs: AS_Id set to Null

  • Table_Fields_Values: Items that are linked

Alarms

  • Alarms: By Alarm_Id

  • Alarm_History: Deleted when alarms are deleted (after all alarms < retention limit deleted then from history where Alarm_Id < minimum Alarm_Id from Alarms)

  • Comments: Items that are linked

Deleted_Variables

  • Variables (Pu_Id = 0 and var_Id > 0)

  • Tests

  • Test_History

  • Array_Data: Items that are linked to Tests

  • Comments: Attached to tests and variables

  • Table_Fields_Values: For tests and variables

Events

  • Events: Deleted by timestamp and PU_Id. The oldest timestamp is found and deleted from that unit.

  • Event_History

  • Event_Details

  • Event_Detail_History

  • Event_Components

  • Event_Component_History

  • PrdExec_Input_Event: Null out Event_id

  • PrdExec_Input_Event_History

  • PrdExec_Input_Event_Transitions

  • PrdExec_Output_Event_History

  • PrdExec_Output_Event_Transitions

  • PrdExec_Output_Event: Null out Event_id

  • Waste_Event_Details

  • Waste_Event_Detail_History

  • Comments (events)

  • User_defined_events: Null out Event_Id

  • Table_Fields_Values (Events, Event_Components, Waste, Prdexec_input_event_History)

  • Event_Status_Transitions

GB_Rsum

  • GB_Rsum

  • GB_RSum_Data

  • Comments: from GB-Rsum

Production_Starts

  • Production_Starts: By end_time (fix chain on all records deleted)

  • Production_Starts_History

  • Comments

Report_Engine_Activity

  • Report_Engine_Activity

Sheet_Columns

  • Sheet_Columns: By Result_On

  • Sheet_Column_History: By Result_On

TaskInstance

(when using the Dataspace purge client with Plant Applications 6.2 SP3, SIM 1503, or higher)

  • TaskInstanceData

  • TaskStepDisplay

  • LindedDocumentInstance_TaskStepInstance

  • TaskStepInstanceData

  • TaskStepInstance

  • TaskInstance

Tests

  • Tests: Deleted by Test_Id

  • Test_History: Deleted when tests are deleted (after all Tests < retention limit deleted, delete from test_history where test_Id < minimum test_Id from tests)

  • Comments: Comments that are linked to Tests

  • Table_Fields_Values: Items that are linked to Tests

  • Array_Data: Delete all data with Should_Delete = 1. Items that are linked to Tests

Timed_Event_Details

  • Timed_Event_Details: Deleted by end_time  and Pu_Id. Find the oldest end_time and delete from that unit

  • Timed_Event_Detail_History: delete when Timed_Event_Details deleted (after all Timed_Event_Details < retention limit deleted. Delete from history where TED_Id < minimum TED_Id from Timed_Event_Details)

  • Table_Fields_Values

  • Comments (action, cause, research, summary research and summary cause)

User_Defined_Events

  • User_Defined_Events: Deleted by end_time  and Pu_Id. Find the oldest end_time and delete from that unit

  • User_Defined_Event_History: Delete when User_Defined_Events deleted (after all User_Defined_Events < retention limit deleted. Delete from history where UDE_Id < minimum UDE_Id from User_Defined_Events)

  • Table_Fields_Values

  • Comments (comment_Id, Action ,cause and research)

Var_Specs

  • Var_Specs: By expiration date (comments not deleted)

Waste_Event_Details

  • Waste_Event_Details: Deleted by Timestamp and Pu_Id. Find the oldest timestamp and delete from that unit

  • Waste_Event_Detail_History: Delete when Waste_Event_Details deleted (after all Waste _Event_Details < retention limit deleted. Delete from history where WED_Id < minimum WED_Id from Waste _Event_Details)

  • Table_Fields_Values

  • Comments (action, cause and research)

Units (Event Based) Tab

On the Units (Event Based) tab, you can purge data associated with specific units. Data that is older than the retention period and associated with the selected units are purged from the following tables:

 NOTE: When deleting by unit (PU_Id), the associated test data is also deleted.

  • Events: Deleted by timestamp and PU_Id. The oldest timestamp is found and deleted from that unit.

  • Event_History

  • Event_Details

  • Event_Detail_History

  • Event_Components

  • Event_Component_History

  • PrdExec_Input_Event: Null out Event_id

  • PrdExec_Input_Event_History

  • PrdExec_Input_Event_Transitions

  • PrdExec_Output_Event_History

  • PrdExec_Output_Event_Transitions

  • PrdExec_Output_Event: Null out Event_id

  • Waste_Event_Details

  • Waste_Event_Detail_History

  • Comments (Events)

  • User_defined_events: Null out Event_Id

  • Table_Fields_Values (Events, Event_Components, Waste, Prdexec_input_event_History)

  • Event_Status_Transitions

  • GB_Rsum

  • GB_RSum_Data

  • Comments: from GB-Rsum

  • Production_Starts: By end_time (fix chain on all records deleted)

  • Production_Starts_History

  • Comments

  • Timed_Event_Details: Deleted by end_time  and Pu_Id. Find the oldest end_time and delete from that unit

  • Timed_Event_Detail_History: delete when Timed_Event_Details deleted (after all Timed_Event_Details  <  retention limit deleted. Delete from history where TED_Id < minimum TED_Id from Timed_Event_Details)

  • Table_Fields_Values

  • Comments (action, cause, research, summary research and summary cause)

  • User_Defined_Events: Deleted by end_time  and Pu_Id. Find the oldest end_time and delete from that unit

  • User_Defined_Event_History: Delete when User_Defined_Events deleted (after all User_Defined_Events < retention limit deleted. Delete from history where UDE_Id < minimum UDE_Id from User_Defined_Events)

  • Table_Fields_Values

  • Comments (comment_Id, Action ,cause and research)

  • Waste_Event_Details: Deleted by Timestamp and Pu_Id. Find the oldest timestamp and delete from that unit

  • Waste_Event_Detail_History: Delete when Waste_Event_Details deleted (after all Waste _Event_Details < retention limit deleted. Delete from history where WED_Id < minimum WED_Id from Waste _Event_Details)

  • Table_Fields_Values

  • Comments (action, cause and research)

Variables (Time Based) Tab

On the Variables (Time Based) tab, you can purge data for specific variables. Data that is older than the retention period and associated with the selected variable are purged from the following tables:

  • Tests: Deleted by Test_Id

  • Test_History: Deleted when tests are deleted (after all Tests < retention limit deleted, delete from test_history where test_Id < minimum test_Id from tests)

  • Comments: Comments that are linked to Tests

  • Table_Fields_Values: Items that are linked to Tests

  • Array_Data: Delete all data with Should_Delete = 1. Items that are linked to Tests