Hi,

I would like to give you a brief introduction on creation of employee, element, creation of fast formula and attaching this fast formula to element for payroll calculation.

I would like to give you a brief introduction on creation of employee, element, creation of fast formula and attaching this fast formula to element for payroll calculation.

**This post includes - Employee creation, element creation, balance creation, simple fast formula creation and checking run result values in payroll/SOE****Requirement:**Employee is attached with 2 elements (Test element 1 & Test element 2) with user enterable inputs. The third element (Test element 3) which is not directly attached to employee in element entries should return the value in run results/SOE using the below formula:

Element 2 = Amount/30 (Amount is input value of Test element 2)

Element3 = 33% of (Element 1 + Element 2)

Where we are covering two requirements:

1. Calculating pay value of element 2 using its own input value of amount using a fast formula (Direct result)

2. Using same formula, calculating the 3

^{rd}element’s pay value which is indirect result as per the requirement**Solution:**

1. Create an employee

2. Create element 1 – Create a balance – Feed this balance to this element – Dimension

3. Create element 2 – Add a new input value of ‘Amount’ – Attach formula to it as in step 6

4. Create element 3 – non recurring

5. Define a formula

6. Assign Formula results to element 2

7. Assign element 1 and element 2 to employee assignment entries

8. Run Quick Pay

9. Check element and balance values in run results/SOE

**Step1:**Creation of employee

**Navigation:**HRMS Manager responsibility à People à Enter and Maintain à (Date track if necessary) New (there are also few other ways of creating employee)

Action would be ‘create Employment’ à Fill all the required information à Save

Go to Assignment à Fill all the required in information à Save

We can go to assignment - entries – to attach elements to employee

Tables: per_all_people_f (_f is for date tracked data)

Per_all_assignments_f

**Step 2:**Creation of elements

**Navigation:**HRMS Manager Responsibility àTotal Compensation à Basic à Element description

Test Element 1 is created as recurring earnings element, similarly create Test element 2

Tables: pay_element_types_f

By default the element is created with a input value called ‘Pay Value’.

User enterable is useful to the end user to enter any input value for the element pay value.

And we can use this element pay value as a database item in fast formula. One database item will be created as soon as this check box is checked with the syntax as <Element Name>_<PAY_VALUE>%

Ex: TEST_ELEMENT_1_PAY_VALUE_ENTRY_VALUE

Table: ff_database_items

Create 2

^{nd}element with priority greater than the priority of 1^{st}element
Created a new input value called ‘Amount’ which is required/mandatory and user enterable.

Create 3

^{rd}element (Test element 3) as non-recurring as this is not useful for calculating the result and should not attach to employee. Main point to be noted is the priority of this element should be greater than the priority of elements 1 and 2. This priority is useful at the time of payroll processing to get balance dimension values.**Step 3:**Create element links to link above elements based on eligibility criteria – Define costing and balancing also for costing...etc...

**Navigation:**HRMS Manager Responsibility àTotal Compensation à Basic à Link

Table(s): select * from pay_element_links_f where element_type_id = --Get element type id from pay_element_types_f

**Step 4:**Creating a balance for the 1st element to get the dimension value of this balance into the fast formula (which is going to attach to 2

^{nd}element)

Navigation: HRMS Manager Responsibility àTotal Compensation à Basic à Balance

Table: pay_balance_types

Add feeds and Dimensions

We can find this feed in element screen after feeding the element to balance, shown below:

**Step 5:**Define formula – Define global values if required

**Navigation:**HRMS Manager Responsibility àTotal Compensation à Basic à Global Values (33%)

Table: ff_globals_f

**Navigation:**HRMS Manager Responsibility àTotal Compensation à Basic à Write Formulas

Table: ff_formulas_f

We can see input values of all elements in ‘Input Values’

Click on ‘Edit’ to open the editor to write the formula

Click on Verify to compile the formula and check if it successfully verified (as given below)

**Step 6:**Create formula results

**Navigation:**HRMS Manager Responsibility àTotal Compensation à Basic à Formula Results

Attach formula to Test element 2:

Enter the element name and Find – Enter processing rules and Formula results as shown below:

Note: As the element 2 is direct value from Amount, type is direct result and element 3 value is indirect from element Test Element 3, type is indirect result for element 3 value.

**Step 7:**Add element 1 and element 2 to employee assignment entries

**Navigation:**HRMS Manager Responsibility à People à Enter and Maintain à Find the employee (TestEMP) à Assignment à Entries

**Step 8:**Run the quick pay and check for run results/SOE

Not only for quick pay, this works for payroll process also. Quick pay is only to run payroll for a particular employee.

**Navigation:**HRMS Manager Responsibility à People à Enter and Maintain à Find the employee (TestEMP) à Assignment à Others à Quick Pay

Tables: pay_run_results, pay_run_result_values

Enter details à Save à Start run

Status will be completed as shown below.

Click on ‘View Results’ to check the values in run results

View results – Run results – Standard Run

As per our requirement,

Element 2 = Amount/30 (Amount is input value of Test element 2)

= 3000/30

= 100

Element3 = 33% of (Element 1 + Element 2)

= 0.33 * (2000 + 100)

= 693

à We can see balance values also in view results – Balances – standard window – query for our balance ‘Element 1 Balance_ASG_RUN’

Similarly, we can see SOE- Statement Of Earnings

View results – SOE – Standard Run – shown below

Your suggestions and inputs are most welcome.

Thank You.

Cheers,

Rajesh

Nice article. Formula uses element1_value. How does the system know that element1_value has the balance of Test Element 1?

ReplyDeleteShould we add element1_value = TEST_ELEMENT_1_PAY_VALUE_ENTRY_VALUE in the formula?

Thanks,Nithin

System automatically creates database items corresponding to each element/balance(s) by appending its dimensions. You can check in ff_database_items table. In this case, yes you are right.

DeleteDear Rajesh,

ReplyDeleteCould you please share the fast formula that you have used here.

Thanks in advance!

Sarathy R

Hi Sarathy,

DeleteThe formula is available in the attached images. This is very simple formula, I just wanted to give a small example.

I am pasting the formula below:

************************************************************/

/* Alias section */

ALIAS ELEMENT_1_BALANCE_ASG_RUN AS Element1_value

/* Default section */

/* Input section */

Inputs are Amount(number)

/*************************************************************

Calculation

**************************************************************/

Element2_value = Amount/30 /* we can take other global value for 30 */

Element3_value = TEST_GLOBAL_VALUE * (Element2_value + Element1_Value)

RETURN Element2_value, Element3_value

Thanks,

Rajesh

Thanks for providing this useful information. I am Payroll expert in Canada and it is good to know about these formulas. I will use it.

ReplyDeleteRajesh Thank You ... GBU

ReplyDeleteI have created a fast formula for Fusion cloud performance ratings-Competency calculation using numeric ratings DBI for performance Templates.The fast formula was compiled successfully,but the value doesn't return in performance documents page correctly.

ReplyDeleteBelow formula i am using,

Formula Type is : performance rating Model.

The Formula as below,

/*================DEFAULT SECTION BEGIN=========================*/

DEFAULT_DATA_VALUE FOR HRA_EVAL_COMP_RATING_FC_CONTENT_ITEM_CODE IS 'XXX'

DEFAULT_DATA_VALUE FOR HRA_EVAL_COMP_RATING_FC_NUMERIC_RATING IS 0

DEFAULT_DATA_VALUE FOR HRA_EVAL_COMP_RATING_FC_TARGET_NUMERIC_RATING IS 0

DEFAULT_DATA_VALUE FOR HRA_EVAL_ITEM_RATING_FC_NUMERIC_RATING IS 0

DEFAULT_DATA_VALUE FOR HRA_EVAL_ITEM_RATING_FC_TARGET_NUMERIC_RATING IS 0

DEFAULT_DATA_VALUE FOR HRA_EVAL_PROFILE_CONTENT_RATING_FC_NUMERIC_RATING IS 0

DEFAULT_DATA_VALUE FOR HRA_EVAL_PROFILE_CONTENT_RATING_FC_TARGET_NUMERIC_RATING IS 0

DEFAULT_DATA_VALUE FOR HRT_RATING_LEVEL_NUMERIC_RATING IS 'XXX'

DEFAULT_DATA_VALUE FOR HRT_PERSON_PRFRAT_NUMERIC_RATING IS 'XXX'

/*DEFAULT_DATA_VALUE FOR HRA_SECTION_RATING_FF_NUMERIC_RATING IS 0*/

/*================DEFAULT SECTION ENDS============================*/

/*================ FORMULA SECTION BEGINS =======================*/

L_RETURN_VALUE = 0

j= 1

while HRA_EVAL_COMP_RATING_FC_CONTENT_ITEM_CODE.EXISTS(j) LOOP

(

L_RETURN_VALUE = HRA_EVAL_ITEM_RATING_FC_TARGET_NUMERIC_RATING[j]) + L_RETURN_VALUE*/

j = j+1

)

/*================ FORMULA SECTION ENDS =======================*/

RETURN L_RETURN_VALUE

Can you please identify where i am missing.

Dear Rajesh,

ReplyDeleteIt's a nice article. I have seen only the calculation part in FF. IF possible can you please share the default and alias details too.

Phen24 is essentially a weight loss solution which works for 24-hours a day! It is known to combine the day and night system and complements your diet

ReplyDeletegenf20 plus

ReplyDeletegenf20 plus gnc

How To Make Your Vagina Tighter In The Most Natural Way

ReplyDeletePhen24 reviews is essentially a weight loss solution which works for 24-hours a day! It is known to combine the day and night system and complements your diet

ReplyDeletenice article.. Thanks Rajesh

ReplyDelete