This content has been marked as final. Show 8 replies
I can't check this, but I'd be very surprised if the system summed at person level across all periods of service. It would be a simple thing to check though - create an employee, give them some sort of payment which feeds a PERITD and an ASGITD dimension, then do a quickpay on them. Terminate and rehire, then repeat. See if the PERITD figure includes the previous period of service.
Which level are you at
Pre 12.0.6 -
Person level balances do not aggregate assignments across periods_of_service.
So PERYTD will only give you summed up data for multiple assignments in the same periods of service.
Post 12.0.6 -
Person Level balances do aggregate assignments across periods_of_Service.
So PERYTD will sum all assignments for the person, across periods_of_service(term, re-hires cases).
Check the thread for more Info -
You can check the actual Sql query. use thie -
Now you can construct a sql statement -
select user_entity_id,definition_text from ff_database_items -- user_entity_id where user_name = 'BASIC_SALARY_PER_YTD'; -- change this to your DBI select route_id from ff_user_entities -- route_id where user_entity_id = 1228; -- user_entity_id from the previous query select text from ff_routes -- text where route_id = 286; -- route_id from previous query
Hope that helps.
Select /* definition_text */ -- from the 1st query from /* text */ -- from the 3rd query
Plese close the thread if your queries are answered.
Sorry, I dont understand -
Could you please share idea regarding creation of our on query through database item?
Are you not able to construct a query using the above notes I provided.
Edited by: Vigneswar Battu on Feb 14, 2013 1:47 PM
You can then see the Sql Query to find the condition (whether it is on person_id or periods_of_service_id)