VSXi CDR Specification / Layout
CDR Format
# |
Field |
Max. ASCII Chars |
Description |
Notes |
CSV |
1 |
Record Sequence Number |
10 |
Unique identification of this record |
A |
|
2 |
Version Number |
5 |
Format version number of records to follow |
B |
|
3 |
Record Type |
1 |
Type of CDR being generated. R – Normal CDR record, A - Audit |
C |
|
4 |
Connection Type |
16 |
Type of Connection |
D |
|
5 |
Session ID |
36 |
Unique ID assigned to the call |
E |
|
6 |
Release Cause |
4 |
More info on Section 2.3 |
F |
|
7 |
Start Time of Date |
32 |
Indicates Time of Date when the call entered the system |
G |
|
8 |
Answer Time of Date |
32 |
Indicates TOD when the call was answered |
H |
|
9 |
Release Time of Date |
32 |
Indicates the TOD when the call was disconnected |
I |
|
10 |
Minutes West of Greenwich Mean Time |
32 |
Minutes West of Greenwich Mean Time. Used to calculate the time zone used on the system for that call. |
J |
|
11 |
Release Cause from Protocol Stack |
32 |
Release cause string from either H323 or SIP protocol stack |
K |
|
12 |
Binary Value of Release Cause from Protocol stack |
4 |
Binary value of the protocol release cause |
L |
|
13 |
1st release dialog |
1 |
O: origination, T: termination, N: internal, E: ERS (external routing server) |
M |
|
14 |
Trunk ID - Origination |
6 |
Trunk ID for origination GW (Resource assigned inbound call leg) |
N |
|
15 |
VoIP Protocol - Origination |
6 |
VoIP protocol for origination dialog |
O |
|
16 |
Origination Source Number |
41 |
Source Number in Origination Dialog |
P |
|
17 |
Origination Source Host Name |
127 |
FQDN or IP address for Source GW in Origination Dialog |
Q |
|
18 |
Origination Destination Number |
41 |
Destination Number in Origination Dialogue |
R |
|
19 |
Origination Destination Host Name |
127 |
FQDN or IP address for Destination GW in Origination Dialogue |
S |
|
20 |
Origination Call ID |
127 |
Unique ID for the origination dialog (origination call leg) |
T |
|
21 |
Origination Remote Payload IP Address |
40 |
Remote Payload IP address for origination dialogue (support IPv6 is new in V1.22) |
U |
|
22 |
Origination Remote Payload UDP Port |
5 |
Remote Payload UDP Port for origination dialogue |
V |
|
23 |
Origination Local Payload IP Address |
40 |
Local Payload IP address for origination dialogue (support IPv6 is new in V1.22) |
W |
|
24 |
Origination Local Payload UDP Port |
5 |
Local Payload UDP Port for origination dialogue |
X |
|
25 |
Origination Codec List |
63 |
Supported codec list (separated by comma) for origination dialog |
Y |
|
26 |
Origination Ingress Packets |
10 |
Number of Ingress (into Sansay VSXi system) payload packets in origination call leg |
Z |
|
27 |
Origination Egress Packets |
10 |
Number of Egress (out from Sansay VSXi system) payload packets in origination call leg |
AA |
|
28 |
Origination Ingress Octets |
10 |
Number of Ingress (into Sansay VSXi system) payload octets in origination call leg |
AB |
|
29 |
Origination Egress Octets |
10 |
Number of Egress (out from Sansay VSXi system) payload octets in origination call leg |
AC |
|
30 |
Origination Ingress Packet Loss |
10 |
Number of Ingress (into Sansay VSXi system) payload packet loss in origination call leg |
AD |
|
31 |
Origination Ingress Delay |
10 |
Average Ingress (into Sansay VSXi system) payload packets delay (in msec) in origination call leg |
AE |
|
32 |
Origination Ingress Packet Jitter |
10 |
Average of Ingress( into Sansay VSXi system) payload packet Jitter (in msec) in origination call leg |
AF |
|
33 |
Trunk ID -- Termination |
6 |
Trunk ID for termination GW(resources) |
AG |
|
34 |
VoIP Protocol - Termination |
6 |
VoIP protocol from termination gateway |
AH |
|
35 |
Termination Source Number |
41 |
Source Number in Termination Dialog |
AI |
|
36 |
Termination Source Host Name |
127 |
FQDN or IP address for Source GW in Termination Dialog |
AJ |
|
37 |
Termination Destination Number |
41 |
Destination Number in Termination Dialog |
AK |
|
38 |
Termination Destination Host Name |
127 |
FQDN or IP address for Destination GW in Termination Dialog |
AL |
|
39 |
Termination Call ID |
127 |
Unique ID for the termination dialog |
AM |
|
40 |
Termination Remote Payload IP Address |
15 |
Remote Payload IP address for termination dialog |
Up to V1.21 |
AN |
40 |
Termination Remote Payload IP Address |
40 |
Remote Payload IP address for termination dialog (support IPv6 is new in V1.22) |
AN |
|
41 |
Termination Remote Payload UDP Port |
5 |
Remote Payload UDP Port for termination dialog |
AO |
|
42 |
Termination Local Payload IP Address |
15 |
Local Payload IP address for termination dialog |
Up to V1.21 |
AP |
42 |
Termination Local Payload IP Address |
40 |
Local Payload IP address for termination dialog (support IPv6 is new in V1.22) |
AP |
|
43 |
Termination Local Payload UDP Port |
5 |
Local Payload UDP Port for termination dialog |
AQ |
|
44 |
Termination Codec List |
63 |
Supported Codec list (separated by comma) for termination dialog |
AR |
|
45 |
Termination Ingress Packets |
10 |
Number of Ingress (into Sansay VSXi system) payload packets in termination call leg |
AS |
|
46 |
Termination Egress Packets |
10 |
Number of Egress (out from Sansay VSXi system) payload packets in termination call leg |
AT |
|
47 |
Termination Ingress Octets |
10 |
Number of Ingress (into Sansay VSXi system) payload octets in termination call leg |
AU |
|
48 |
Termination Egress Octets |
10 |
Number of Egress (out from Sansay VSXi system) payload octets in termination call leg |
AV |
|
49 |
Termination Ingress Packet Loss |
10 |
Number of Ingress (into Sansay VSXi system) payload packet loss in termination call leg |
AW |
|
50 |
Termination Ingress Delay |
10 |
Average Ingress (into Sansay VSXi system) payload packets delay (in msec) in termination call leg |
AX |
|
51 |
Termination Ingress Packet Jitter |
10 |
Average of Ingress (into Sansay VSXi system) payload packet Jitter (in msec) in termination call leg |
AY |
|
52 |
Final Route Indication |
1 |
F: Final Route Selection, I: Intermediate Route Attempt |
New in V1.3 |
AZ |
53 |
Routing Digits |
41 |
Routing Digit (Digit after Inbound translation, before Outbound Translation). |
New in V1.5 |
BA |
54 |
Call Duration in seconds. (Not to be used for billing). |
10 |
Call Duration in Seconds. 0 if this is failed call. Time is truncated, we recommend using the millisecond duration field for billing instead. |
New in V1.5 |
BB |
55 |
Origination Post Dial Delay in seconds |
6 |
Post dial delay (from call attempt to ring). 0 if this is failed call |
New in V1.6 |
BC |
56 |
Ring Time in seconds |
6 |
Ring Time in Seconds. 0 if this is failed call |
New in V1.6 |
BD |
57 |
Duration in milliseconds |
10 |
Call duration in milliseconds. |
New in V1.8 |
BE |
58 |
Conf ID |
35 |
Unique Conference ID for this call |
New in V1.9 |
BF |
59 |
RPID/PAI |
41 |
User-part from the Remote-Party-ID or P-Asserted-Identity header |
New in V1.10 |
BG |
60 |
Route Entry Index |
2 |
1-8, indicate the relative index in a route entry |
New in V1.11 |
BH |
61 |
Route Table Used |
5 |
1-59,999 |
New in V1.11 |
BI |
62 |
LNP Dipped |
1 |
The call has been through External LNP server. 1: Yes, 0: No |
New in V1.12 |
BJ |
63 |
Ingress LRN |
41 |
Routed Number (RN) from Ingress Call Attempt if present |
New in V1.12 |
BK |
64 |
Egress LRN |
41 |
Egress RN sent to termination leg |
New in V1.12 |
BL |
65 |
CNAM Dipped |
1 |
CNAM server has been queried for this call, 1: Yes, 0: No |
New in V1.12 |
BM |
66 |
DNC Dipped |
1 |
DNC (Do Not Call) Server has been queried for this call, 1: Yes, 0: No |
New in V1.12 |
BN |
67 |
Origination TID Alias Name ( as configured in Resource Page) |
28 |
Can be used as Company ID if configured in Resource page |
New in V1.13. Increased length in V1.18. |
BO |
68 |
Termination TID Alias Name (as configured in Resource Page) |
28 |
Can be used as Company ID if configured in Resource page |
New in V1.13. Increased length in V1.18. |
BP |
69 |
External Route Server Dipped |
1 |
Did call query an ERS; 1: Yes; 0: No |
New in V1.14 |
BQ |
70 |
OLI Digits |
7 |
Inbound OLI Digits if they were present |
New in V1.15 |
BR |
71 |
Routing Match |
41 |
This is the digits that were matched in the route entry |
New in V1.16 |
BS |
72 |
Termination PDD in milliseconds |
6 |
The Post Dial Delay provided by this call leg |
New in V1.16 |
BT |
73 |
P-Charge-Info |
41 |
The Proxy Charge Information presented on the call |
New in V1.16 |
BU |
74 |
JIP |
41 |
The Jurisdictional Indication Parameter presented on the call |
New in V1.16 |
BV |
75 |
Matched Digits in ERS |
41 |
The routed digits matched in the ERS route tables |
New in V1.17 |
BW |
76 |
Route Table in ERS |
5 |
The route table that was used by the ERS for this call |
New in V1.17 |
BX |
77 |
Route Sequence number in ERS |
2 |
This is the sequence number in the route match used for this call |
New in V1.17 |
BY |
78 |
Jurisdiction Type used in ERS |
5 |
This is the JD Type that was determined by the ERS for this call |
New in V1.17 |
BZ |
79 |
Reason Cause Value from Protocol Stack |
32 |
SIP Reason header Q.850 cause code value |
New in V1.19 |
CA |
80 |
Mapped Cause Code |
3 |
Post-Cause Code Profile Code |
New in V1.19 |
CB |
81 |
Mapped Reason Cause Value |
3 |
Post-Cause Code Profile Reason header Q.850 cause code value |
New in V1.19 |
CC |
82 |
Reason Cause Text from Protocol Stack |
32 |
SIP Reason header Q.850 text string received from Protocol Stack |
New in V1.19 |
CD |
83 |
Diversion/History-Info |
41 |
ANI from Diversion/History-Info header |
New in V1.20 |
CE |
84 |
Origination Burst Loss Count |
10 |
Total number of RTP discontinuations in the origination forward RTP stream. |
New in V1.21 |
CF |
85 |
Origination MOS (multiplied by 10) |
2 |
Mean Opinion Score (MOS) of the origination forward RTP stream. |
New in V1.21 |
CG |
86 |
Origination R-Factor |
3 |
R-Factor of the origination forward RTP stream |
New in V1.21 |
CH |
87 |
Termination Burst Loss Count |
10 |
Total number of RTP discontinuations in the termination forward RTP stream. |
New in V1.21 |
CI |
88 |
Termination MOS (multiplied by 10) |
2 |
Mean Opinion Score (MOS) of the termination forward RTP stream. |
New in V1.21 |
CJ |
89 |
Termination R-Factor |
3 |
R-Factor of the termination forward RTP stream |
New in V1.21 |
CK |
90 |
Transcoding |
1 |
Was media actually transcoded, 0: No, 1: Yes |
New in V1.23 |
CL |
91 |
Origination SRTP |
1 |
SRTP on the origination call leg, 0: No, 1: Yes, 2: Yes with DTLS |
New in V1.23 |
CM |
92 |
Termination SRTP |
1 |
SRTP on the termination call leg, 0: No, 1: Yes, 2: Yes with DTLS |
New in V1.23 |
CN |
93 |
FAS (False Answer Supervision) Duration in milliseconds |
10 |
FAS duration in milliseconds (on termination leg), 0 means FAS not detected |
New in V1.24 |
CO |
94 |
FAS Idle (No Packet) Duration in milliseconds |
10 |
FAS idle (no packet) duration in milliseconds (on termination leg) |
New in V1.24 |
CP |
95 |
Caller Identity Header Presence |
1 |
Call was received with an Identity Header 0: No Identity Header 1: Identity Header Present |
New in V1.25 |
CQ |
96 |
Caller Identity Authentication |
2 |
Status of Caller Identity Authentication One or two characters. One character: 0: No Authentication E: Authentication Failed M: timeout/communication error with Authentication server Two characters: 1st character: A: Auth success with attestation level A B: Auth success with attestation level B C: Auth success with attestation level C N: No attestation (added to support base PASSPorT). Added in V1.27. 2nd character: I: Attestation from incoming INVITE N: Attestation from NSS/STI-AS dip R: Attestation from ERS dip |
New in V1.25 Changed in V1.27 |
CR |
97 |
Egress Caller Identity Header |
1 |
0: Identity Header Not Sent 1: Identity Header Sent |
New in V1.25 |
CS |
98 |
Caller Identity Verification |
1 |
Status of Caller Identify Verification 0: No Verification N: Verification Incomplete due to error V: Verified OK C: Verification not sent due to error in configuration. E: Verification Failed M: Timeout/Communication error with Verification Server |
New in V1.25 |
CT |
99 |
Customer Rate |
10 |
Customer Rate Info 0.000000 - 99.9999 |
New in V1.26 |
CU |
100 |
Vendor Rate |
10 |
Vendor Rate Info 0.000000 - 99.9999 |
New in V1.26 |
CV |
101 |
Caller Identity Header origid |
36 |
UUID version 1 variant 10 as specified in RFC4122. xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx consisting of:
|
New in V1.26 |
CW |
102 |
Origination Video |
1 |
Video on the origination call leg.0: No, 1: Yes |
New in V1.27 |
CX |
103 |
Termination Video |
1 |
Video on the termination call leg.0: No, 1: Yes |
New in V1.27 |
CY |
104 |
Diversion headers |
3 |
Number of Diversion headers |
New in V1.28 |
CZ |
105 |
Ingress DIV |
3 |
Number of Diversion passports on the inbound side |
New in V1.28 |
DA |
106 |
Egress DIV |
3 |
Number of Diversion passports on the outbound side |
New in V1.28 |
DB |
107 |
Inbound RCD claim present |
1 |
either as a separate RCD Passport or inside the Shaken Passport. Expected values are 0,1 |
New in V1.29 |
DC |
108 |
Outbound RCD claim present |
1 |
either as a separate RCD Passport or inside the Shaken Passport.Expected values are 0,1 |
New in V1.29 |
DD |
4 replies
-
Hi
Do you have the excel file with the new headers to analice the CDRs? -
When is the OrigID going into the CDRs?
-
Can you provide an example of how to decode the origid? Psuedo-code would be helpful.
-
Hi Sansay Team
CDR file attached is not V1.27 cause the last column is CT which corresponds to v1.25
According to provided info we should get a .xlsx file till CY
Kindly update the file