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 1 changed 4 lines
ELPL - Element Pay Line Values
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.
The ELPL operator can only be used with the Operand Type of ET.
Statement: If a part time employee worked more than 30 hours in the 1st week of the biweekly pay period, create a warning on the Exceptions Report.
!!ELPL - Element Pay Line Values
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|PAY_ELEMENT] for a date range in the current employment.
To determine the value of an element across multiple employments you must use the function [P2K_CF_FMLAHRS]
There are two ways that this operator may be used:\\
\\1) To determine the value from the beginning of the Pay Period to a date passed as Operand 3.\\
\\2) To determine the value between any two dates, which requires additional set up **\\
\\** You must define a variable with the name (exactly-lowercase) 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.
\\** The variables elpl_begin_date and elpl_end_date must be re-declared after each time the ELPL operand is called.
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.
%%information The ELPL operator can only be used with the Operand Type of ET.%%
;Example 1:If a part time employee worked more than 30 hours in the 1st week of the biweekly pay period, create a warning on the Exceptions Report.\\
At line 6 changed 6 lines
00010 IF DB DGR.GROUP_CODE EQ A PART-TIME 00100 99999
00100 LET V WK1 END DATE EW $S PERIOD-START_DATE 00110
00110 LET V WK1 TIME WRKD ELPL ET TIME WRKD V WK1 END DATE 00120
00120 IF V WK1 TIME WRKD GT N 30 00200 99999
00200 MSG A PT EE >30 HRS WK1 99999
99999 EXIT 99999
|00010|IF|DB|DGR.GROUP_CODE|EQ|A|PART-TIME| | |00100|99999
|00100| LET|V|WK1 END DATE|EW|$S|PERIOD-START_DATE| | |00110|
|00110|LET|V|WK1 TIME WRKD|ELPL|ET|TIME WRKD|V|WK1 END DATE|00120|
|00120|IF|V|WK1 TIME WRKD|GT|N|30| | |00200|99999
|00200|MSG|A|PT EE >30 HRS WK1| | | | | |99999|
|99999|EXIT| | | | | | | |99999|
At line 30 added 17 lines
;Example 2:Determine if an employee worked on a specific day. If they did give them the amount of time defined on IEAS as Hours Per Day.\\
||Line||CMD||OT||Operand 1||OPER||OT||Operand2||OT||Operand3||If Goto|| Else GoTo
|00100| LET|V|elpl_begin_date|EQ|D|24-DEC-2013| | |00200|
|00200| LET|V|elpl_end_date|EQ|D|24-DEC-2013| | |00300|
|00300|LET|V|HOL TIME WRKD|ELPL|ET|STAT WRKD| | |00400|
|00400|IF|V|HOL TIME WRKD|GT|N|30| | |01000|99999
|00200|LET|PC|630|EQ|DB|EASD.HOURS_PER_DAY| | |99999|
|99999|EXIT| | | | | | | |99999|
----
![Notes|Edit:Internal.ELPL_OPERATOR]
[{InsertPage page='Internal.ELPL_OPERATOR' default='Click to create a new notes page'}]