!!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.\\ ||Line||CMD||OT||Operand 1||OPER||OT||Operand2||OT||Operand3||If Goto|| Else GoTo |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| ;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'}]