Wiki: ELPL_OPERATOR

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

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	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 #

Click to create a new notes page