The Purge History (UMHP) form is used to physically delete rows from the database that are no longer necessary or that are passed there legal requirement for holding on to.
Report Parameters | |
---|---|
Trace Level | Optional, LOV Available When performing a trial calculation, you may specify the level of message that the calculation report should display. This field is used for troubleshooting purposes ‘Exceptions Only’ is the default value |
For tables that have a column called expiry or end date these columns are used for checking against the retention date. For all other tables the change date column is used.
Once an effective date table has been processed, its date adjustment procedure will be run to ensure continuity from the beginning to the end of time as we know it.
01 Years | Specify the number of years to keep rows in the table. For example: retained periods was 2 and the system date is 15-JAN-2000 then any rows who's qualifying date is less than or equal to 15-JAN-1998 on the table being processed, will be deleted. |
02 Months | Specify the number of months to keep rows in the table. For example: retained periods was 6 and the system date is 15-JAN-2000 then any rows who's qualifying date is less than or equal to 15-JUL-1999 on the table being processed, will be deleted. |
03 Weeks | Specify the number of weeks to keep rows in the table. For example: retained periods was 1 and the system date is 15-JAN-2000 then any rows who's qualifying date is less than or equal to 08-JAN-2000 on the table being processed, will be deleted. |
04 Days | Specify the number of days to keep rows in the table. For example: retained periods was 30 and the system date is 15-JAN-2000 then any rows who's qualifying date is less than or equal to 16-DEC-1999 on the table being processed, will be deleted. |
To run execute the function UMHP. BACKUP the database BEFORE executing a History Purge.
Include list of tables with possible recommendations.
Screen captures are meant to be indicative of the concept being presented and may not reflect the current screen design.
If you have any comments or questions please email the Wiki Editor
All content © High Line Corporation