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:#
NumberErrors:#
Examples:#
P2K_SEGR(~,SYSDATE,'01','1') will return the wage rate on the assignment detail to an annual ('01') rate basis.