P2K_PPAMTS.SPELTOT#
Functionality#
This database function will return the to-date value of the pay components included in the indicated element for the specified employee.Parameters:#
EEM_ID | The ID for the employee’s employment record |
PEL_ID | The ID for the Element (see P2K_PPAMTS.SPGETPEL) |
TODATE_TYPE | The type of “to-date” records you want to the data for (see below) |
CALENDAR_PERIOD | The specific period you are interested in |
Returns:#
NumericErrors:#
If an invalid parameter is passed, then zero is returnedExample:#
P2K_PPAMTS.SPELTOT(EEM_ID,P2K_PPAMTS.SPGETPEL('TOTAL FRINGE'),'Q','200404')
Operation#
The format of Calendar period should match the to-date type according to the following table. In this example, we assume that the fiscal year starts in March, so that is the first month of the fiscal year:To-Date_Type | Meaning | Calendar Period |
---|---|---|
‘Y’ | Year To Date for 2004 | 2004 |
‘Q’ | Quarter to date for 2nd Quarter | 200402 |
‘M’ | Month to date for May | 200405 |
‘F’ | Fiscal Month to Date for May | 200403 |
‘A | Assignment to date | EAS_ID (Assignment ID) for the employee's assignment |