AirlineFlightSchedules : ident and actual_ident not matching

[Cablrtechnologly]

Hello Dogrock

Thank you for sharing link with information. Still, I need your more input here, please.

Previously, We had a question about calculating delay of flight. Here is the link of it, in which we did discussion:

How can we identify that flight is late while departure

Hello Dogrock Thank you for answering my question. First: After reading question, I found that faFlightId of our both’s answer were different. So, I think you/I have used wrong flight, can you correct it? who’s faFlightID is correct? Second: As per explanation of @bovineone in link: Please explain about filed_ete, filed_departuretime and esti filed_ete is the estimated time enroute at the time the flight plan was filed(duration of time required to flight). Let’s fill value in your equation…

After reading your answer, we found that we selected wrong flight. So, Delay information was wrong. So, we try to search those flight whose actual indent is either BLANK OR same as indent. and, Above issues arise.

Now, How can Cablr-system know that Flight has codeshare flight?