This page (revision-11) was last changed on 26-Nov-2021 10:22 by ihowie

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
11 26-Nov-2021 10:22 2 KB ihowie to previous
10 26-Nov-2021 10:22 2 KB ihowie to previous | to last
9 26-Nov-2021 10:22 2 KB khiggs to previous | to last
8 26-Nov-2021 10:22 2 KB khiggs to previous | to last
7 26-Nov-2021 10:22 2 KB khiggs to previous | to last
6 26-Nov-2021 10:22 1 KB rforbes to previous | to last
5 26-Nov-2021 10:22 1 KB RForbes to previous | to last
4 26-Nov-2021 10:22 1 KB RForbes to previous | to last
3 26-Nov-2021 10:22 1 KB JMyers to previous | to last
2 26-Nov-2021 10:22 1 KB JMyers to previous | to last
1 26-Nov-2021 10:22 1 KB JMyers to last

Page References

Incoming links Outgoing links

Version management

Difference between version and

At line 3 changed one line
On rare occasions, it may be necessary to know the value of a group of pay components for all the transactions in the pay period up to a given date. In this case, the ELPL (Elementary Pay Line Values) operator and the ET (Transaction to Date) operand type may be used to access this information. All transactions with an effective date greater than or equal to the period start, and less than or equal to the given date, will be returned.
On occasions, it may be necessary to know the value of a group of pay components for all the transactions (Pay Lines) for a given date range. In this case, the ELPL orperator will determine the value of an [element|ELEMENTS] for a date range.
At line 5 added 9 lines
There are two ways taht this operator may be used:
* To determine the value from the beginning of the Pay Period to a date passed as Operand 3.
* To determine the value between any two dates, which requires additional set up
** You must define a variable with the name (exactly) as ELPL_BEGIN_DATE, date format, which contains the start date for your inquiry
** Also define a variable with the name (exactly) as ELPL_END_DATE, date format, which contains the end date for your inquiry
** The use of ELPL only looks at Operand 2 for the name of the element.
All transactions with an effective date greater than or equal to the period start (or ELPL_BEGIN_DATE), and less than or equal to the given date in Operand 3 (or ELPL_END_DATE), will be returned.