!!!P2K_SPPGWAGE

!Functionality:
This function will return the Wage Rate of the identified employee, for the as of date in units as requested, deriving the wage rate according to Source value

!Parameters:
|EEM_ID      | The ID for the employee
|ASOF_DATE   | The “As OF” date to be considered
|SOURCE      | What source[1] should be used to get this wage
|HIGHER_OF    | (optional) if set to ‘1’, will return whichever is higher – the prime assignment wage or the requested wage (based on SOURCE)
|EAS_ID       | (optional) The ID of the assignment (which may not necessarily be the prime assignment)
|DJB_ID       | (optional) The ID of the job code to be referenced
|DPS_ID       | (optional) The ID of the position code to be referenced
|BASIS        | The rate basis[2] that the wage should be returned in

!Returns:
Numeric

!Errors:
If an invalid parameter is passed, then null is returned
	
!Example:

{{P2K_SPPGWAGE(~,SYSDATE,'01',NULL,NULL,NULL,NULL,'01')}}

Will return the prime assignment wage, as an annual wage

{{P2K_SPPGWAGE(~,SYSDATE,'03','1',null,null,887,null,'02')}}
Will return the higher of prime assignment wage or the wage for the position identified with ID 887, as an monthly wage


[1 - Sources|#1]
||Source Type ||Meaning
| ‘01’        | Prime Assignment
| ‘02’        | Other Assignment (provide EAS_ID)
| ‘03’        | Job (provide DJB_ID)
| ‘04’        | Position (provide DPS_ID)

[2 - Rate basis|#2]
||Basis Type  ||Meaning
| ‘01’        | Annual
| ‘02’        | Monthly
| ‘03’        | Semi Monthly
| ‘04’        | Bi Weekly
| ‘05’        | Weekly
| ‘06’        | Daily
| ‘07’        | Hourly


----
![Notes|Edit:Internal.P2K_SPPGWAGE] 	
[{InsertPage page='Internal.P2K_SPPGWAGE' default='Click to create a new notes page'}]