id,order_event,beneficiary_id,provider_service_name,provider_code,order_type,external_order_id,provider_order_id,status,retry_count,last_polled_at,retried_at,error_message,reason_for_refusal,push_response_json,patient_first_name,patient_last_name,patient_date_of_birth,patient_sex,created_by,created_date,modified_by,last_mod_date,deleted,vanID,parkingPlaceID,visitCode,processed,vanSerialNo,SyncedDate,Syncedby,SyncFailureReason
1,STOP_TB_REFERRAL,931295299318,EMRLITE,EMRLITE,XRAY_CHEST,931295299318-745176-XRAY_CHEST,NULL,FAILED,544,"2026-08-10 17:12:10",NULL,"Order not found on provider (404): externalOrderId=931295299318-745176-XRAY_CHEST",NULL,NULL,V,KAVERI,2017-08-08,Female,NULL,"2026-08-09 17:02:42",NULL,"2026-08-10 17:12:10",0,414,44,745176,F,1,"2026-10-13 10:44:38",BHADRAvan2,"INSERT: Duplicate key: tb_diagnostic_order.uk_diagnostic_order_external_order_id"
2,STOP_TB_REFERRAL,442408960289,EMRLITE,EMRLITE,XRAY_CHEST,442408960289-611641-XRAY_CHEST,NULL,FAILED,543,"2026-08-10 17:12:10",NULL,"Order not found on provider (404): externalOrderId=442408960289-611641-XRAY_CHEST",NULL,NULL,Y,HEMALATHA,2003-06-04,Female,NULL,"2026-08-09 17:03:42",NULL,"2026-08-10 17:12:10",0,414,44,611641,F,2,"2026-10-13 10:44:38",BHADRAvan2,"INSERT: Duplicate key: tb_diagnostic_order.uk_diagnostic_order_external_order_id"
7,STOP_TB_REFERRAL,340649021451,EMRLITE,EMRLITE,XRAY_CHEST,340649021451-475333-XRAY_CHEST,NULL,FAILED,540,"2026-08-10 17:12:10",NULL,"Order not found on provider (404): externalOrderId=340649021451-475333-XRAY_CHEST",NULL,NULL,CHIRAK,K,1993-08-08,Male,NULL,"2026-08-09 17:07:49",NULL,"2026-08-10 17:12:10",0,414,44,475333,F,7,"2026-10-13 10:44:38",BHADRAvan2,"INSERT: Duplicate key: tb_diagnostic_order.uk_diagnostic_order_external_order_id"
18,STOP_TB_REFERRAL,319377518126,EMRLITE,EMRLITE,MTB,319377518126-377234-MTB,NULL,FAILED,353,"2026-08-10 17:18:46",NULL,"Order not found on provider (404): externalOrderId=319377518126-377234-MTB",NULL,NULL,MADHAV,RAM,1993-08-02,Male,NULL,"2026-08-09 20:31:16",NULL,"2026-08-10 17:18:46",0,414,44,377234,F,18,"2026-10-13 10:44:38",BHADRAvan2,"INSERT: Duplicate key: tb_diagnostic_order.uk_diagnostic_order_external_order_id"
20,STOP_TB_REFERRAL,941538167860,EMRLITE,EMRLITE,XRAY_CHEST,941538167860-732557-XRAY_CHEST,NULL,FAILED,499,"2026-08-10 17:12:10",NULL,"Order not found on provider (404): externalOrderId=941538167860-732557-XRAY_CHEST",NULL,NULL,R,RAMESH,1986-08-08,Male,NULL,"2026-08-09 20:38:26",NULL,"2026-08-10 17:12:10",0,414,44,732557,F,20,"2026-10-13 10:44:38",BHADRAvan2,"INSERT: Duplicate key: tb_diagnostic_order.uk_diagnostic_order_external_order_id"
23,STOP_TB_REFERRAL,698073675871,EMRLITE,EMRLITE,MTB,698073675871-467801-MTB,NULL,FAILED,291,"2026-08-10 17:17:46",NULL,"Order not found on provider (404): externalOrderId=698073675871-467801-MTB",NULL,NULL,R,RADHIKA,2002-08-08,Female,NULL,"2026-08-09 23:25:17",NULL,"2026-08-10 17:17:46",0,414,44,467801,F,23,"2026-10-13 10:44:38",BHADRAvan2,"INSERT: Duplicate key: tb_diagnostic_order.uk_diagnostic_order_external_order_id"
48,STOP_TB_REFERRAL,258321937146,EMRLITE,EMRLITE,XRAY_CHEST,258321937146-211007-XRAY_CHEST,NULL,FAILED,11,"2026-08-10 17:17:46",NULL,"Order not found on provider (404): externalOrderId=258321937146-211007-XRAY_CHEST",NULL,NULL,PRANITH,KUMBRUKA,2023-11-09,Male,NULL,"2026-08-10 17:04:45",NULL,"2026-08-10 17:17:46",0,414,44,211007,F,48,"2026-10-13 10:44:38",BHADRAvan2,"INSERT: Duplicate key: tb_diagnostic_order.uk_diagnostic_order_external_order_id"
49,STOP_TB_REFERRAL,588975232187,EMRLITE,EMRLITE,XRAY_CHEST,588975232187-410483-XRAY_CHEST,NULL,FAILED,10,"2026-08-10 17:17:46",NULL,"Order not found on provider (404): externalOrderId=588975232187-410483-XRAY_CHEST",NULL,NULL,TRIVENI,TOYAKA,1994-07-04,Female,NULL,"2026-08-10 17:10:12",NULL,"2026-08-10 17:17:46",0,414,44,410483,F,49,"2026-10-13 10:44:38",BHADRAvan2,"INSERT: Duplicate key: tb_diagnostic_order.uk_diagnostic_order_external_order_id"
76,STOP_TB_REFERRAL,983601926844,EMRLITE,EMRLITE,XRAY_CHEST,983601926844-398609-XRAY_CHEST,NULL,FAILED,21,"2026-08-11 10:45:47",NULL,"Order not found on provider (404): externalOrderId=983601926844-398609-XRAY_CHEST",NULL,NULL,HARSHAVARDHAN,KONDAGORRI,2001-06-24,Male,NULL,"2026-08-11 10:31:54",NULL,"2026-08-11 10:45:47",0,414,44,398609,F,76,"2026-10-13 10:44:38",BHADRAvan2,"INSERT: Duplicate key: tb_diagnostic_order.uk_diagnostic_order_external_order_id"
104,STOP_TB_REFERRAL,205968337317,EMRLITE,EMRLITE,XRAY_CHEST,205968337317-320854-XRAY_CHEST,205968337317-320854-XRAY_CHEST,COMPLETED,104,"2026-08-11 12:37:19",NULL,NULL,NULL,NULL,GANESH,PALLERIKA,2000-07-07,Male,NULL,"2026-08-11 10:57:32",NULL,"2026-08-11 12:37:19",0,414,44,320854,F,104,"2026-10-13 10:44:38",BHADRAvan2,"INSERT: Duplicate key: tb_diagnostic_order.uk_diagnostic_order_external_order_id"
224,STOP_TB_REFERRAL,710456521181,EMRLITE,EMRLITE,XRAY_CHEST,710456521181-424310-XRAY_CHEST,NULL,FAILED,0,"2026-08-11 13:39:24",NULL,"Order not found on provider (404): externalOrderId=710456521181-424310-XRAY_CHEST",NULL,NULL,NOOKALU,PALLERIKA,1975-09-09,Female,NULL,"2026-08-11 13:39:24",NULL,"2026-08-11 13:39:24",0,414,44,424310,F,224,"2026-10-13 10:44:38",BHADRAvan2,"INSERT: Duplicate key: tb_diagnostic_order.uk_diagnostic_order_external_order_id"
250,STOP_TB_REFERRAL,776995816707,EMRLITE,EMRLITE,XRAY_CHEST,776995816707-232560-XRAY_CHEST,NULL,FAILED,187,"2026-08-24 11:05:18",NULL,"No push response recorded for this order — cannot poll",NULL,NULL,MAHESWARARAO,PALLERIKA,1970-09-09,Male,NULL,"2026-08-12 09:38:01",NULL,"2026-08-24 11:05:18",0,414,44,232560,F,250,"2026-10-13 10:44:38",BHADRAvan2,"INSERT: Duplicate key: tb_diagnostic_order.uk_diagnostic_order_external_order_id"
274,STOP_TB_REFERRAL,873534134379,EMRLITE,EMRLITE,XRAY_CHEST,873534134379-218793-XRAY_CHEST,NULL,FAILED,178,"2026-08-24 11:05:18",NULL,"No push response recorded for this order — cannot poll",NULL,NULL,ESWARARAO,BIDDIKA,1996-01-01,Male,NULL,"2026-08-12 13:17:59",NULL,"2026-08-24 11:05:18",0,414,44,218793,F,274,"2026-10-13 10:44:38",BHADRAvan2,"INSERT: Duplicate key: tb_diagnostic_order.uk_diagnostic_order_external_order_id"
411,STOP_TB_REFERRAL,214153828314,EMRLITE,EMRLITE,XRAY_CHEST,214153828314-235661-XRAY_CHEST,NULL,FAILED,84,"2026-08-24 11:05:18",NULL,"No push response recorded for this order — cannot poll",NULL,NULL,SAMPATH,NIMMALA,2014-12-29,Male,NULL,"2026-08-14 10:48:45",NULL,"2026-08-24 11:05:18",0,414,44,235661,F,411,"2026-10-13 10:44:38",BHADRAvan2,"INSERT: Duplicate key: tb_diagnostic_order.uk_diagnostic_order_external_order_id"
412,STOP_TB_REFERRAL,205460257869,EMRLITE,EMRLITE,XRAY_CHEST,205460257869-251853-XRAY_CHEST,NULL,FAILED,84,"2026-08-24 11:05:18",NULL,"No push response recorded for this order — cannot poll",NULL,NULL,SATHVIK,BIDDIKA,2016-08-11,Male,NULL,"2026-08-14 10:48:48",NULL,"2026-08-24 11:05:18",0,414,44,251853,F,412,"2026-10-13 10:44:38",BHADRAvan2,"INSERT: Duplicate key: tb_diagnostic_order.uk_diagnostic_order_external_order_id"
413,STOP_TB_REFERRAL,821077261517,EMRLITE,EMRLITE,XRAY_CHEST,821077261517-363905-XRAY_CHEST,NULL,FAILED,84,"2026-08-24 11:05:18",NULL,"No push response recorded for this order — cannot poll",NULL,NULL,JHANVIN,BIDDIKA,2018-08-10,Male,NULL,"2026-08-14 10:48:52",NULL,"2026-08-24 11:05:18",0,414,44,363905,F,413,"2026-10-13 10:44:38",BHADRAvan2,"INSERT: Duplicate key: tb_diagnostic_order.uk_diagnostic_order_external_order_id"
414,STOP_TB_REFERRAL,459003782941,EMRLITE,EMRLITE,XRAY_CHEST,459003782941-818046-XRAY_CHEST,NULL,FAILED,84,"2026-08-24 11:05:18",NULL,"No push response recorded for this order — cannot poll",NULL,NULL,SIMHACHALAM,BIDDIKA,2016-12-07,Male,NULL,"2026-08-14 10:49:02",NULL,"2026-08-24 11:05:18",0,414,44,818046,F,414,"2026-10-13 10:44:38",BHADRAvan2,"INSERT: Duplicate key: tb_diagnostic_order.uk_diagnostic_order_external_order_id"
415,STOP_TB_REFERRAL,473386085287,EMRLITE,EMRLITE,XRAY_CHEST,473386085287-169754-XRAY_CHEST,NULL,FAILED,84,"2026-08-24 11:05:18",NULL,"No push response recorded for this order — cannot poll",NULL,NULL,AKHIL,MANDANGI,2019-03-27,Male,NULL,"2026-08-14 10:49:18",NULL,"2026-08-24 11:05:18",0,414,44,169754,F,415,"2026-10-13 10:44:38",BHADRAvan2,"INSERT: Duplicate key: tb_diagnostic_order.uk_diagnostic_order_external_order_id"
416,STOP_TB_REFERRAL,403454609255,EMRLITE,EMRLITE,XRAY_CHEST,403454609255-478745-XRAY_CHEST,NULL,FAILED,84,"2026-08-24 11:05:18",NULL,"No push response recorded for this order — cannot poll",NULL,NULL,CHERRY,PATTIKA,2016-12-07,Male,NULL,"2026-08-14 10:49:22",NULL,"2026-08-24 11:05:18",0,414,44,478745,F,416,"2026-10-13 10:44:38",BHADRAvan2,"INSERT: Duplicate key: tb_diagnostic_order.uk_diagnostic_order_external_order_id"
417,STOP_TB_REFERRAL,841817762753,EMRLITE,EMRLITE,XRAY_CHEST,841817762753-181234-XRAY_CHEST,NULL,FAILED,84,"2026-08-24 11:05:18",NULL,"No push response recorded for this order — cannot poll",NULL,NULL,SANDEEP,PUVVALA,2018-03-01,Male,NULL,"2026-08-14 10:49:37",NULL,"2026-08-24 11:05:18",0,414,44,181234,F,417,"2026-10-13 10:44:38",BHADRAvan2,"INSERT: Duplicate key: tb_diagnostic_order.uk_diagnostic_order_external_order_id"
418,STOP_TB_REFERRAL,709547059063,EMRLITE,EMRLITE,XRAY_CHEST,709547059063-242690-XRAY_CHEST,NULL,FAILED,84,"2026-08-24 11:05:18",NULL,"No push response recorded for this order — cannot poll",NULL,NULL,RISHIKUMAR,MANDANGI,2018-08-29,Male,NULL,"2026-08-14 10:49:39",NULL,"2026-08-24 11:05:18",0,414,44,242690,F,418,"2026-10-13 10:44:38",BHADRAvan2,"INSERT: Duplicate key: tb_diagnostic_order.uk_diagnostic_order_external_order_id"
419,STOP_TB_REFERRAL,926805138092,EMRLITE,EMRLITE,XRAY_CHEST,926805138092-768079-XRAY_CHEST,NULL,FAILED,84,"2026-08-24 11:05:18",NULL,"No push response recorded for this order — cannot poll",NULL,NULL,NANI,PUVVALA,2019-04-29,Male,NULL,"2026-08-14 10:49:45",NULL,"2026-08-24 11:05:18",0,414,44,768079,F,419,"2026-10-13 10:44:38",BHADRAvan2,"INSERT: Duplicate key: tb_diagnostic_order.uk_diagnostic_order_external_order_id"
420,STOP_TB_REFERRAL,787714896639,EMRLITE,EMRLITE,XRAY_CHEST,787714896639-418603-XRAY_CHEST,NULL,FAILED,84,"2026-08-24 11:05:18",NULL,"No push response recorded for this order — cannot poll",NULL,NULL,ANIL,KONDAGORRI,2017-04-11,Male,NULL,"2026-08-14 10:49:51",NULL,"2026-08-24 11:05:18",0,414,44,418603,F,420,"2026-10-13 10:44:38",BHADRAvan2,"INSERT: Duplicate key: tb_diagnostic_order.uk_diagnostic_order_external_order_id"
421,STOP_TB_REFERRAL,394899500037,EMRLITE,EMRLITE,XRAY_CHEST,394899500037-528077-XRAY_CHEST,NULL,FAILED,84,"2026-08-24 11:05:18",NULL,"No push response recorded for this order — cannot poll",NULL,NULL,"KUMARA SWAMY",BIDDIKA,2019-03-06,Male,NULL,"2026-08-14 10:49:52",NULL,"2026-08-24 11:05:18",0,414,44,528077,F,421,"2026-10-13 10:44:38",BHADRAvan2,"INSERT: Duplicate key: tb_diagnostic_order.uk_diagnostic_order_external_order_id"
422,STOP_TB_REFERRAL,887282923689,EMRLITE,EMRLITE,XRAY_CHEST,887282923689-357791-XRAY_CHEST,NULL,FAILED,84,"2026-08-24 11:05:18",NULL,"No push response recorded for this order — cannot poll",NULL,NULL,"RAVINDRA TEJA",BIDDIKA,2017-06-24,Male,NULL,"2026-08-14 10:50:15",NULL,"2026-08-24 11:05:18",0,414,44,357791,F,422,"2026-10-13 10:44:38",BHADRAvan2,"INSERT: Duplicate key: tb_diagnostic_order.uk_diagnostic_order_external_order_id"
423,STOP_TB_REFERRAL,972299891000,EMRLITE,EMRLITE,XRAY_CHEST,972299891000-886031-XRAY_CHEST,NULL,FAILED,84,"2026-08-24 11:05:18",NULL,"No push response recorded for this order — cannot poll",NULL,NULL,KARTHIK,TOYAKA,2014-01-11,Male,NULL,"2026-08-14 10:50:22",NULL,"2026-08-24 11:05:18",0,414,44,886031,F,423,"2026-10-13 10:44:38",BHADRAvan2,"INSERT: Duplicate key: tb_diagnostic_order.uk_diagnostic_order_external_order_id"
424,STOP_TB_REFERRAL,805861186514,EMRLITE,EMRLITE,XRAY_CHEST,805861186514-342060-XRAY_CHEST,NULL,FAILED,84,"2026-08-24 11:05:18",NULL,"No push response recorded for this order — cannot poll",NULL,NULL,SINGANNA,PATTIKA,1954-01-01,Male,NULL,"2026-08-14 10:50:38",NULL,"2026-08-24 11:05:19",0,414,44,342060,F,424,"2026-10-13 10:44:38",BHADRAvan2,"INSERT: Duplicate key: tb_diagnostic_order.uk_diagnostic_order_external_order_id"
425,STOP_TB_REFERRAL,682956309249,EMRLITE,EMRLITE,XRAY_CHEST,682956309249-776937-XRAY_CHEST,NULL,FAILED,84,"2026-08-24 11:05:19",NULL,"No push response recorded for this order — cannot poll",NULL,NULL,MAHESWARARAO,TOYAKA,1993-10-16,Male,NULL,"2026-08-14 10:50:39",NULL,"2026-08-24 11:05:19",0,414,44,776937,F,425,"2026-10-13 10:44:38",BHADRAvan2,"INSERT: Duplicate key: tb_diagnostic_order.uk_diagnostic_order_external_order_id"
426,STOP_TB_REFERRAL,949215428230,EMRLITE,EMRLITE,XRAY_CHEST,949215428230-517495-XRAY_CHEST,NULL,FAILED,84,"2026-08-24 11:05:19",NULL,"No push response recorded for this order — cannot poll",NULL,NULL,PRAMOD,NIMMALA,2017-06-02,Male,NULL,"2026-08-14 10:50:40",NULL,"2026-08-24 11:05:19",0,414,44,517495,F,426,"2026-10-13 10:44:38",BHADRAvan2,"INSERT: Duplicate key: tb_diagnostic_order.uk_diagnostic_order_external_order_id"
427,STOP_TB_REFERRAL,302525994959,EMRLITE,EMRLITE,XRAY_CHEST,302525994959-954805-XRAY_CHEST,NULL,FAILED,84,"2026-08-24 11:05:19",NULL,"No push response recorded for this order — cannot poll",NULL,NULL,NESHA,PALLERIKA,2020-09-23,Female,NULL,"2026-08-14 10:50:45",NULL,"2026-08-24 11:05:19",0,414,44,954805,F,427,"2026-10-13 10:44:38",BHADRAvan2,"INSERT: Duplicate key: tb_diagnostic_order.uk_diagnostic_order_external_order_id"
NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,
