!!!P2K_PPAMTS.SPPCTOT

!Functionality
This database function will return the to-date value of the pay component 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

%%information 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] %%