Skip to Content

Need SF successfactor Query for Payroll Integration

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')

Regards

DV

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • 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

    Add comment
    10|10000 characters needed characters exceeded