Wiki: P 2 K

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:#

Examples:#

P2K_SEGR(~,SYSDATE,'01','1') will return the wage rate on the assignment detail to an annual ('01') rate basis.

CLEANUP

Notes #

Click to create a new notes page

Screen captures are meant to be indicative of the concept being presented and may not reflect the current screen design.
If you have any comments or questions please email the Wiki Editor