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