How to enter direct salary for new hires in EPBCS
Summary
How to enter direct salary for new hires in EPBCSContent
I have been asked how to do this for a while, so I spent the last few nights and worked on the following solution. The enhancement is very simple and still allows you to execute driver-based planning as well as the direct salary input. The attached video demonstrates all of the changes, and the member formula is attached below.
Code Snippet
IF(@ismbr(@relative("YearTotal",0))) IF("OWP_Status"->"No Property" == [OWP_Status.Active] OR "OWP_Status"->"No Property" == [OWP_Status.Maternity]) /*Is there data in the Manual input Current Yearlevel*/ IF("OWP_Salary Basis"->"BegBalance"->"Salary_Input" <> #MISSING AND "OWP_Value"->"BegBalance"->"Salary_Input" <>#MISSING) IF ("OWP_Salary Basis"->"BegBalance"->"Salary_Input"==2 ) /* Weekly */ "OWP_Expense Amount"=((("OWP_Value"->"BegBalance"->"Salary_Input" )*52)/"NumPeriods")*("OWP_FTE"->"No Property" - "OWP_Reconciled FTE"->"No Property")*"OWP_Partial Payment Factor"->"No Property"; ELSEIF ("OWP_Salary Basis"->"BegBalance"->"Salary_Input"==3) /* Annual */ "OWP_Expense amount"=(("OWP_Value"->"BegBalance"->"Salary_Input" )* [TimeBalanceSpread])*("OWP_FTE"->"No Property" - "OWP_Reconciled FTE"->"No Property")*"OWP_Partial Payment Factor"->"No Property"; ELSEIF ("OWP_Salary Basis"->"BegBalance"->"Salary_Input"==4 ) /* Bi-Weekly */ "OWP_Expense amount"=((("OWP_Value"->"BegBalance"->"Salary_Input" )*26)*[TimeBalanceSpread])*("OWP_FTE"->"No Property" - "OWP_Reconciled FTE"->"No Property")*"OWP_Partial Payment Factor"->"No Property"; ELSEIF("OWP_Salary Basis"->"BegBalance"->"Salary_Input"==1) /* Hourly */ "OWP_Expense amount"=((("OWP_Value"->"BegBalance"->"Salary_Input" )*52*"Hours per Week"->"No Property")*[TimeBalanceSpread])*("OWP_FTE"->"No Property" - "OWP_Reconciled FTE"->"No Property")*"OWP_Partial Payment Factor"->"No Property"; ELSEIF("OWP_Salary Basis"->"BegBalance"->"Salary_Input"==5) /* Monthly */ "OWP_Expense amount"=((("OWP_Value"->"BegBalance"->"Salary_Input"
Tagged:
4