...
SIPXCDR database stores all call events occured during the process of establishing a call. Every call event is saved in the call_state_events table
Analysis
Column event_type holds the event type sent
R - Call Request
T - Transfer call Event
S - Call Established Event
F - Call failed event
E - Normal End Call event
...