P 2 K_PPAMTS.SPELTOT

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

Numeric

Errors:#

If an invalid parameter is passed, then zero is returned

Example:#

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
Note that FISCAL TO DATE is not fiscal Year-to-Date but is fiscal Month-To-Date following the fiscal months as defined in the fiscal calendar on IDCL


Notes #

Click to create a new notes page