P2K_PPAMTS.SPELPAY#

Functionality#

This database function will return the value of the pay components included in the identified element for the specified pay header.

Parameters:#

PPH_ID	The ID for the pay header record
PEL_ID	The ID for the element (see P2K_PPAMTS.SPGETPEL)

Returns:#

Numeric

Errors:#

If an invalid parameter is passed, then zero is returned

If there is no value or record for that pay header and element pair, then NULL is returned

Example:#

P2K_PPAMTS.SPELPAY(PPH_ID,P2K_PPAMTS.SPGETPEL('TOTAL_EARNS')) will get the ID of the element TOTAL_EARNS (in the reference to P2K_PPAMTS.SPGETPEL) for the Pay Header identified by the PPH_ID.

Operation#

Note that the pay header does not have to be closed or in any status at all other than having been calculated at least once (even in a trial payrun).

---

Notes #

Click to create a new notes page