Skip to Content

Need SF successfactor Query for Payroll Integration

Apr 24 at 03:40 PM


avatar image

Hi Experts

I am doing the integration for success-factor to SFTP in which i am using SFAPI Compound employee. My Scenario is we need to create the files Report for employees which are active in last month and also i need to include the timeoff details for all employees selected, mainly it's payroll data like we have salary report for last month of all employees

i am using following query but not giving the right output:

SELECT person, personal_information, employment_information, job_information, compensation_information, paycompensation_recurring, paycompensation_non_recurring, payment_information FROM CompoundEmployee Where fromDate = to_date('2018-02-01','YYYY-MM-DD') and toDate = to_date('2018-02-28','YYYY-MM-DD') and last_modified_on > to_datetime('2018-02-01T00:00:00Z')



10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Praveen Tirumareddy
Apr 24 at 05:22 PM

Hi Viswanath,

Could you please specify what is the exact error are you getting. Do you mean the query is not working at all or you are getting both active and inactive employee records.

thanks and regards,

Praveen T

10 |10000 characters needed characters left characters exceeded