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.