P2K_PPAMTS.SPPCTOT_FILTER#
Functionality#
This database function will return the to-date value of the pay component for the specified employee, also applying any of the optional filters indicated.Parameters:#
EEM_ID | The ID for the employeeâs employment record |
PPC_ID | The ID for the pay component (see P2K_PPAMTS.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 |
EAS_ID | If specifying âAssignment ToDateâ you can narrow down to a specific assignment |
DGR_ID | The ID of the group (which implies Unit, and Government EINs) from IDGR |
DSP_ID_HOME | The ID of the State/Prov of their home (IEPI) |
DSP_ID_WORK | The ID of the State/Prov that they work in (IEAS) |
DSD_ID | The ID of their School District (IEPI) |
DTX_ID_HOME | The ID of the Tax Jurisdiction of their home (IEPI) |
DTX_ID_WORK | The ID of the Tax Jurisdiction of their work (IEAS) |
FILTER_FED_REGIST |
Returns:#
NumericErrors:#
If an invalid parameter is passed, then zero is returnedExample:#
P2K_PPAMTS.SPPCTOT(EEM_ID,P2K_PPAMTS.SPGETPPC('1240'),'Q','200404',null,null,33))
This example will get the QTD value for Pay Component 1240 for the fourth quarter of 2004, but only for those values that were for the employee's home state (where the state has an ID of 33).
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 |