This page (revision-7) was last changed on 06-Jun-2022 17:31 by Kevin Higgs

This page was created on 26-Nov-2021 10:22 by JMyers

Only authorized users are allowed to rename pages.

Only authorized users are allowed to delete pages.

Page revision history

Version Date Modified Size Author Changes ... Change note
7 06-Jun-2022 17:31 8 KB Kevin Higgs to previous
6 26-Nov-2021 10:22 2 KB kparrott to previous | to last
5 26-Nov-2021 10:22 2 KB jmyers to previous | to last
4 26-Nov-2021 10:22 2 KB rforbes to previous | to last
3 26-Nov-2021 10:22 2 KB JMyers to previous | to last
2 26-Nov-2021 10:22 2 KB JMyers to previous | to last
1 26-Nov-2021 10:22 2 KB JMyers to last

Page References

Incoming links Outgoing links

Version management

Difference between version and

At line 5 changed 3 lines
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
||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
At line 9 changed 5 lines
This process could take a very long time to run depending on the number of tables setup and the amount of data in each table as sequential reads will be done to check each rows dates for qualifying to be deleted.
Based on Table Details (IMTD) - processes tables that are set up with either
X Retained Periods (Numeric) and Period Type (Lexicon - see below) are both not null, or
X Purge Date is not null
Note: Purge Date will take precedence IF all three fields are filled in. Thus if you have it set to normally delete rows that are older then 5 years BUT for a special run want to delete all rows prior to a specific date, you can.
%%information This process could take a very long time to run depending on the number of tables setup and the amount of data in each table as sequential reads will be done to check each rows dates for qualifying to be deleted.%%
!!Based on Table Details (IMTD)
Processes tables that are set up with either
*Retained Periods (Numeric) and Period Type (Lexicon - see below) are both not null, or
*Purge Date is not null
%%information Purge Date will take precedence IF all three fields are filled in. Thus if you have it set to normally delete rows that are older then 5 years BUT for a special run want to delete all rows prior to a specific date, you can.%%