This page (revision-8) was last changed on 02-Aug-2023 15:50 by Lilia Urtan

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

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
8 02-Aug-2023 15:50 2 KB Lilia Urtan to previous
7 02-Aug-2023 15:49 2 KB Lilia Urtan to previous | to last
6 26-Nov-2021 10:22 2 KB Lilia Urtan to previous | to last
5 26-Nov-2021 10:22 1 KB JMyers to previous | to last FROM_DATE ==> FROM_DATE(Field)
4 26-Nov-2021 10:22 1 KB JMyers to previous | to last TO_DATE ==> TO_DATE(Oracle_Function)
3 26-Nov-2021 10:22 1 KB JEscott to previous | to last
2 26-Nov-2021 10:22 1 KB JEscott to previous | to last
1 26-Nov-2021 10:22 1 KB JEscott to last

Page References

Incoming links Outgoing links
IEMDA
IEMDA

Version management

Difference between version and

At line 6 added 4 lines
The From and To dates for the Designated Approver are used to filter approval records against the Approval Time stamp column. NOT the system AS OF DATE. This means that the date the approval record is created assigns responsibility to the approver. If the Designated Approver was active when the approval record was "created" (APPROVAL_TIMESTAMP is the column used in filters) then the responsibility of that approval remain the designates responsibility until it's handled (Approved/Declined). When the current date passes the "To" date, this does NOT relieve responsibility of the approval since the creation date of the approval does not change.
This page (revision-8) was last changed on 02-Aug-2023 15:50 by Lilia UrtanTop