AnsweredAssumed Answered

One of the effective dated record is getting dropped in Boomi

Question asked by rudrappa.m388810 on Oct 20, 2016
Latest reply on Dec 4, 2016 by Srinivas Chandrakanth Vangari

Hi,

I'm facing the below issue, please let me know if any one has a solution for this.

 

Scenario:

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?

 

Query used:

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

 

 

NOTE:- queryMode:delta

Outcomes