!!!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|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|RATE_BASIS] that describes the source wage rate.  If not provided, '07' (Hourly) is used.

!Returns:
Number

!Errors:
When NO_DATA_FOUND return null

!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|Edit:Internal.P2K_SEGR] 	
[{InsertPage page='Internal.P2K_SEGR' default='Click to create a new notes page'}]