2

VSXi CDR Specification / Layout

CDR Format

CDR Header

 

#

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

 

Record Data

Variable

Parameters defined in CDR Body

   

CDR Body

#

Field

Max. ASCII Chars

Description

Notes

CSV

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

63

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

2nd character: 

I: Attestation from incoming INVITE 

N: Attestation from NSS/STI-AS dip 

R: Attestation from ERS dip

New in V1.25

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 Identify Header origid

36

UUID version 1 variant 10 as specified in RFC4122.

xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx

consisting of: 

  • 60-bit timestamp - 100 nsecs since 15-Oct-1582

  • Last 5 nibbles of NSS IP address)

  • 6-byte Service Provider Code

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

4 replies

null
    • moises_amiga
    • 4 yrs ago
    • Reported - view

    Hi
    Do you have the excel file with the new headers to analice the CDRs?

    • Glen_Gerhard
    • 3 yrs ago
    • Reported - view

    When is the OrigID going into the CDRs?

    • calvin_ellison
    • 2 yrs ago
    • Reported - view

    Can you provide an example of how to decode the origid? Psuedo-code would be helpful.

    • Moises_Smeke
    • 6 mths ago
    • Reported - view

    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