As part of a global change of its fare structure, PROLOGIS is responsible for migrating all future segments to a new fare structure. An ETL process has been developed to extract all related PNR details, including SSRs / seats and fees and store that data temporarily inside an SQL database. The second phase of migration will be to create an API script for cancelling / re-booking the segments based on the extracted data and an external fare mapping document.