I'm facing the below issue, please let me know if any one has a solution for this.
One of the employee (XXXXX) was terminated in SF on October 18th with the termination date as Oct 19th. This employee should have been sent to target on Sept 19th (interface scheduled date). However it was not sent. Please let me know what could be the reason?
SELECT address_information,compensation_information,email_information,employment_information,job_information,national_id_card,paycompensation_non_recurring,paycompensation_recurring,person,personal_information,phone_information FROM CompoundEmployee WHERE
(last_modified_on > to_datetime('2016-10-14T13:13:32Z')<--This is LSRD
AND fromDate = to_date('2016-10-12','yyyy-MM-dd')<--current date-7 days
AND toDate = to_date('2016-10-19','yyyy-MM-dd'))
AND company_territory_code IN ('USA')
AND person_id_external IN ('XXXXX')