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 10 changed one line
!!Based on Table Details (IMTD)
!Based on Table Details ([IMTD])
At line 18 added one line
At line 19 changed 5 lines
Period Types
X 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.
X 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.
X 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.
X 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.
!Period Types
|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.
At line 28 added one line
At line 30 added 5 lines
----
![Notes|Edit:Internal.UMHP]
[{InsertPage page='Internal.UMHP' default='Click to create a new notes page'}]