The purged data is stored in tab-delimited ASCII file. The name of the file is assigned by the purge process. The purged data file is then zipped into the appropriate zip file as defined by the purge process. Information about a purge is stored in a series of control tables in the database for later use and retrieval.
The control table contains some or all of the following columns (depending on your system):
Main control table
purge_number |
integer |
primary key system assigned number (must not be null) |
purge_date |
datetime |
(must not be null) |
purge_type |
char(1) |
U = unattended, M = Manual (must not be null) |
purge_start_date |
datetime |
starting criteria date (must not be null) |
purge_end_date |
datetime |
ending criteria date (must not be null) |
user_name |
varchar(30) |
if purge_type = U then will be equal to ‘unattended’ (must not be null) |
zip_file_name |
varchar(50) |
(must not be null) |
Purged header tables
purge_number |
integer |
primary key - foreign key to main table (must not be null) |
purged_table |
varchar(50) |
primary key (must not be null) |
text_file_name |
varchar(50) |
(must not be null) |
Note
The zip files are located in an archive location (defined in Purge Parameters).