ELPL_OPERATOR
Back to current versionRestore this version

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 for a date range.

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) 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.

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.

LineCMDOTOperand 1OPEROTOperand2OTOperand3If Goto Else GoTo
00010IFDBDGR.GROUP_CODEEQAPART-TIME 0010099999
00100 LETVWK1 END DATEEW$SPERIOD-START_DATE 00110
00110LETVWK1 TIME WRKDELPLETTIME WRKDVWK1 END DATE00120
00120IFVWK1 TIME WRKDGTN30 0020099999
00200MSGAPT EE >30 HRS WK1 99999
99999EXIT 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.

LineCMDOTOperand 1OPEROTOperand2OTOperand3If Goto Else GoTo
00100 LETVELPL_BEGIN_DATEEQD24-DEC-2013 00200
00200 LETVELPL_END_DATEEQD24-DEC-2013 00300
00300LETVHOL TIME WRKDELPLETSTAT WRKD 00400
00400IFVHOL TIME WRKDGTN30 0100099999
00200LETPC630EQDBEASD.HOURS_PER_DAY 99999
99999EXIT 99999


Notes #

Click to create a new notes page