This is version 1 2 3 . It is not the current version, and thus it cannot be edited.

Back to current versionRestore this version

P2K_PPAMTS.SPPCTOT#

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
PPC_ID	The ID for the pay component (see P2K_SPGETPPC)
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.SPPCTOT(EEM_ID,P2K_PPAMTS.SPGETPPC('1240'),'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