Please enable JavaScript.
Coggle requires JavaScript to display documents.
Bag Claim (Operation service ) (Bag_claim,, ref_loss_cd, , bag_tag_number,…
Bag Claim (Operation service )
Bag_claim,
ref_loss_cd
, bag_tag_number
bag_hist
bag_flt_leg_hist
booking
rtf_snapshot
bag damage
bag pilferage
bag lost
bag delay
Flight cancellation
Booking Action < cancellation < Booking_Inactive
BK_ACTIVE_DTMZ <= CNXL_DTMZ
BK_INACTIVE_DTMZ >= CNXL_DTMZ
Booking
RTF_Snapshot
RTF_flt_leg_operation_cnxl
Customer cancelled
UA Cancelled flights
Flight_Delay
Line of flight delay
( Segment+
Schedule change
)
Schedule Change
( IRROP )
No rebook
or
No IRROP
0
future segment
no travelled segment
Last segment and sub Lof
same co -terminal
ACT_ARRV_DTMZ
-
SCH_ARRV_DTMZ
Rebook
Due to
IRROP
Rebook With in 48 prior to departure
rebook
after
flight cancellation
ACT_DPRT_DTMZ
-
SCH_DPRT_DTMZ
> 20 mins
AND
BK_INACTIVE_DTMZ+4 hours
>
FLT_DPRT_DTMZ
Diversion
delayed but Travelled flight
ACT_DPRT_DTMZ
-
SCH_DPRT_DTMZ
> 20 mins
Cutomer books another flight if current flight is delayed
Segment Delay
( Operational delay on single
segment
)
Actual - scheduled
Booking
ACI_pax_ckin
RTF_Snapshot
RTF_flt_leg_operation_cnxl
Deny Boarding
Voluntary Deny Boarding
Customer is ok for next avaible flight
Involundatary Deny Boarding
Customer is not ok even compensation is given
Os_pax
Cabin Downgrade/upgrade
Aci_pax_ckin_full
Cabin Upgrade
Cabin Downgrade
Overnight stay
Booking
RTF_Snapshot
RTF_flt_leg_operation_cnxl
overnight stay
Booking
RTF_Snapshot
RTF_flt_leg_operation_cnxl
UA
New (
Palantir Foundry
)
Customer Signal Hub
576 signals
Trip Narrative (
customer Experience
)
15 tables
- Database (
tripNarrative
)
Use cases
Compensation
Decisions
Drive customer reliability
metrics
Future -
analytical
building
Old
Opera
Legacy Trip Narrative application
Deny Boarding
Voluntary ( customer is ok )
Involuntary ( customer is not ok )
Trip Narrative
Customer Metrics
Overall calculation on trip metrics
Trip Metrics
Hyd(10 AM )
Mumbai
12 AM - 12:30 AM
Delhi
Expected
Hyd(11:30 AM)
Mumbai
13:30 AM - 2:30 AM
Delhi
Expected
Programs
programs
UNAR_unintended(1)
UNAR_LOG (1)
LOF_logic (1)
TN Events ( simple ) - 62
Event Identification Disservice Index (9)
Flight Cancellation
Flight Delay
Deny Boarding
Bag Claim
Cabin downgrade
Cabin upgrade
Overnight Stay
E to E+ upgrade
E+ to E downgrade
E+ to E Downgrade / upgrade
Aci_pax_ckin_full
Segment
One travel from source to destination
Line of flight