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

Back to current versionRestore this version

P2K_SEGR#

Functionality#

This database function will transform a wage rate from one basis to another, taking into account many variable factors.

Parameters#

EASD_ID	The ID of the P2K_HR_ASSIGNMENT_DETAILS record
AS_OF_DATE	A date that is used to determine other factors as described below
TO_RATE_BASIS	The rate basis that you want your wage rate converted to.
TO_WAGE_FTE	Use FTE on the incoming wage
FROM_WAGE_RATE	Optional Wage rate as the source wage rate. If not provided, the wage rate from the assignment detail is used.
FROM_RATE_BASIS	Optional Rate basis that describes the source wage rate. If not provided, '07' (Hourly) is used.

Returns:#

Number

Errors:#

If an invalid parameter is passed, then NULL is returned If there is no value then NULL is returned

Examples:#

P2K_SEGR(~,SYSDATE,'01','1') - Using the EASD_ID as the first parameter (~) this will return the wage rate on the assignment detail to an annual ('01') rate basis.

P2K_SEGR(~,[350005],'04',[353522],[353527],[353528]) - Using the EASD_ID as the first parameter (~), the AS OF DATE as the second (350005), a RATE_BASIS of '04' (Bi-Weekly), and the FTE(353522), WAGE_RATE(353527) and the original RATE_BASIS (353528) from the EASD record, return the wage rate for the assignment detail to an Biweekly '04') rate basis.

---

Notes #

Click to create a new notes page