Appendix A: Call Detail Block File Fields

Table Of Contents

Call Detail Block File Fields

Call Detail Block File Fields

---

The Cisco BTS 10200 system stores the raw call detail blocks (CDBs) in a flat file ASCII based format on the persistent store associated with the Bulk Data Management System (BDMS) for retention purposes. The Cisco BTS 10200 stores a minimum of 10 megabytes of billing records in a circular file implementation. This data is subsequently sent to the specified remote accounting office or billing server or mediation device via the File Transfer Protocol (FTP).

The following section illustrates the format of each field in a Call Detail Block (CDB), the order in which it occurs, the possible values for the individual fields and the meaning of the data within the field where applicable.

The delimiters used to separate fields within a record or records within a file can be any one of the following:

•semi-colon ";"

•vertical bar "|"

•linefeed

•comma ","

•caret "^".

---

Note The same character (value) cannot be used as both a field delimiter and a record delimiter. Different delimiters must be used to separate fields within a record and records within a file.

---

The CDB field and record separators are defined in the platform.cfg file that is read at initialization time. The platform.cfg file associated with the BDMS platform must be updated for changes to take affect; however, the file cannot be changed without a system restart. Both active and standby BDMS platforms must be restarted to pick up any change of delimiters.

The [ProcessParameter] block to update is "ProcName=BMG." The parameter to update is "Args." To change the field delimiter you must update the "-FD" option. To change the record delimiter you must update the "-RD" option.

---

Caution Once the delimiters are changed and the BDMSs are restarted, any billing files created with different delimiters will be inaccessible by the billing query command. An example of an actual call detail block FTP file containing one CDB is shown in "Example Call Detail Block File".

---

Table A-1 provides information detailing the information contained in the fields in the output files transmitted from the Element Management System (EMS) on the Cisco BTS 10200 Softswitch.

.

Table A-1 Call Detail Block Field Descriptions 

Field Number	Common Name	Field Type	Field Size*	Potential Values	Field Description
1	Call Type	Numeric		0 = NULL 1 = TEST-CALL 2 = INTL 3 = LOCAL 4 = TOLL 5 = INTERLATA 6 = TANDEM 7 = EMG 8 = NON-EMG 9 = DA 10 = DA-TOLL 11 = REPAIR 12 = RELAY 13 = BUSINESS 14 = TOLL-FREE 15 = 900 16 = 500 17 = 700 18 = 976 19 = VACANT 20 = PCS 21 = INVALID 22 = NONE 23 = LRN 24 = EXTENSION 25 = CUT-THRU 26 = OPERATOR 27 = CARRIER-OPERATOR 28 = OPERATOR-ASSISTED 29 = BLV 30 = SPEED-DIAL 31 = NATIONAL 32= TW 33 = INFO 34 = PREMIUM 35 = ATTENDANT 36 = NAS 37 = POLICE 38 = FIRE 39 = AMBULANCE 40 = TIME 41 = WEATHER 42 = TRAFFIC 43 = LOOPBACK_TEST 44 = INTL_OPERATOR 45 = NATL_OPERATOR 46 = AIRLINES 47 = RAILWAYS 48 = SERVICE_CODE 49 = INTL_WORLD_ZONE_1	The nature of the call, which indicates the type of accounting processing to apply to it.Call Type "NULL" is used for any calls that do not progress to the point where a lookup in the Destination table occurs, or if routing is not needed—as in cases of feature activation or deactivation.
2	Signal Start Time	Numeric		32 bit unsigned value in GMT epoch time format. The number of seconds since Jan 1, 1970 0:00:00h.	Time starts on receipt of an MGCP NTFY or SS7 IAM. If the value is NULL, timestamp is ignored.
3	Signal Stop Time	Numeric		32 bit unsigned value in GMT epoch time format. The number of seconds since Jan 1, 1970 0:00:00h. If the value is NULL, the timestamp is to be ignored.	Time stops on the last of the following signaling events: 1) MGCP DLCX receipt 2) transmission/receipt of an RLC 3) transmission/receipt of last signaling message to/from a peer CMS/MGC.
4	Interconnect Start Time	Numeric		32 bit unsigned value in GMT epoch time format. The number of seconds since Jan 1,1970 0:00:00h. If the value is NULL, the timestamp is to be ignored.	Time starts on commitment of bandwidth between the IP/ATM and PSTN networks.
5	Interconnect Stop Time	Numeric		32 bit unsigned value in GMT epoch time format. The number of seconds since Jan 1,1970 0:00:00h. If the value is NULL, the timestamp is to be ignored.	Time stops on release of bandwidth between the IP/ATM and PSTN networks.
6	Call Connect Time	Numeric		32 bit unsigned value in GMT epoch time format. The number of seconds since Jan 1,1970 0:00:00h. If the value is NULL, the timestamp is to be ignored.	Time starts on receipt of an MGCP NTFY indicating off-hook, or SS7 ANS, or answer indication from the media gateway for an operator services trunk.
7	Call Answer Time	Numeric		32 bit unsigned value in GMT epoch time format. The number of seconds since Jan 1,1970 0:00:00h. If the value is NULL, the timestamp is to be ignored.	Time starts on both parties being off-hook for at least 2 seconds. Currently the Cisco BTS 10200 does not support Short Supervisory Transitions, so the contents of this field and field #6 will be identical.
8	Call Disconnect Time	Numeric		32 bit unsigned value in GMT epoch time format. The number of seconds since Jan 1,1970 0:00:00h. If the value is NULL, the timestamp is to be ignored.	Time starts on receipt of an MGCP NTFY indicating on-hook of the calling party, or expiration of the call-continuation timer, an SS7 REL, or an indication from the media gateway that the operator services trunk has disconnected.
9	Database Query Time1	Numeric		32 bit unsigned value in GMT epoch time format. The number of seconds since Jan 1,1970 0:00:00h. If the value is NULL, the timestamp is to be ignored.	The time the first database query response was received for this call.
10	Service Instance Time1	Numeric		32 bit unsigned value in GMT epoch time format. The number of seconds since Jan 1,1970 0:00:00h. If the value is NULL, the timestamp is to be ignored.	The time the instance of Service Type 1 occurred.
11	Service Instance Time2	Numeric		32 bit unsigned value in GMT epoch time format. The number of seconds since Jan 1,1970 0:00:00h. If the value is NULL, the timestamp is to be ignored.	The time the instance of Service Type 2 occurred.
12	Service Instance Time3	Numeric		32 bit unsigned value in GMT epoch time format. The number of seconds since Jan 1,1970 0:00:00h. If the value is NULL, the timestamp is to be ignored.	The time the instance of Service Type 3 occurred.
13	Service Activation Time1	Numeric		32 bit unsigned value in GMT epoch time format. The number of seconds since Jan 1,1970 0:00:00h. If the value is NULL, the timestamp is to be ignored.	The time the activation of Service Type 1 occurred.
14	Service Activation Time2	Numeric		32 bit unsigned value in GMT epoch time format. The number of seconds since Jan 1,1970 0:00:00h. If the value is NULL, the timestamp is to be ignored.	The time the activation of Service Type 2 occurred.
15	Service Activation Time3	Numeric		32 bit unsigned value in GMT epoch time format. The number of seconds since Jan 1,1970 0:00:00h. If the value is NULL, the timestamp is to be ignored.	The time the activation of Service Type 3 occurred.
16	Service Deactivation Time1	Numeric		32 bit unsigned value in GMT epoch time format. The number of seconds since Jan 1,1970 0:00:00h. If the value is NULL, the timestamp is to be ignored.	The time the deactivation of Service Type 1 occurred.
17	Service Deactivation Time2	Numeric		32 bit unsigned value in GMT epoch time format. The number of seconds since Jan 1,1970 0:00:00h. If the value is NULL, the timestamp is to be ignored.	The time the deactivation of Service Type 2 occurred.
18	Service Deactivation Time3	Numeric		32 bit unsigned value in GMT epoch time format. The number of seconds since Jan 1,1970 0:00:00h. If the value is NULL, the timestamp is to be ignored.	The time the deactivation of Service Type 3 occurred.
19	Call Elapsed Time	String	11	(DDDDD):HH:MM:SS	The duration that the voice path was established. The days (DDDDD) portion of this field is optional and variable in length depending on the number of days the calls has been connected. If this field is NULL, then no data was captured for this record.
20	Interconnect Elapsed Time	String	11	(DDDDD):HH:MM:SS	The duration that bandwidth was established with another carrier. The days (DDDDD) portion of this field is optional and variable in length depending on the number of days the calls has been connected. If this field is NULL, then no data was captured for this record.
21	Originating QOS Time	Numeric		32 bit unsigned value in GMT epoch time format. The number of seconds since Jan 1,1970 0:00:00h. If the value is NULL, the timestamp is to be ignored.	The time that the originating side QoS measurements were collected. If this field is NULL, then the associated Originating QoS parameters are to be ignored.
22	Terminating QOS Time	Numeric		32 bit unsigned value in GMT epoch time format. The number of seconds since Jan 1,1970 0:00:00h. If the value is NULL, the timestamp is to be ignored.	The time that the terminating side QoS measurements were collected. If this field is NULL, then the associated Terminating QoS parameters are to be ignored.
23	Originating Number	String	64	DIGITS	This field contains the calling party number after it has gone through the complete translation process on the BTS including any possible overriding. If this field is NULL, then no data was captured for this field.
24	Terminating Number	String	64	DIGITS	Directory number of the terminating party. If this field is NULL, then no data was captured for this record.
25	Charge Number	String	64	DIGITS	Directory number of the billable party. For Mexican ISUP scenarios this field is populated with the tarrification number. If this field is NULL, then no data was captured for this record.
26	Location Routing Number	String	64	DIGITS	The location routing number (LRN) of the switch to which the directory number has been ported. If this field is NULL, then no data was captured for this record.
27	Dialed Digits	String	64	DIGITS This field contains the actual digits dialed by the originator of the call. This field only contains digits dialed in the first stage of the call when dialed by a subscriber that is homed on the Cisco BTS 10200 Softswitch.	This field is intended for troubleshooting purposes only. If the call is terminating to this switch from a subscriber homed elsewhere, then this field will contain the information in the ieCldPartyNum field. In this case - the digits stored may have been manipulated after the originator dialed. If this field is NULL, then no data was captured for this record.
28	Forwarding Number	String	64	DIGITS	Directory number that is forwarding the call to another subscriber's DN. This field is populated only in the call forwarding instance record leg, not in the normal call leg that terminated to the forwarding number. If this field is NULL, then no data was captured for this record.
29	Service Type 1	Numeric		1 = CALL_BLOCK	Class name of the first service invoked in call. If this field is NULL, then no data was captured for this record.
				2 = CALL_FORWARD_UNCONDITIONAL 3 = CALL_WAITING 4 = REPEAT_CALL 5 = RETURN_CALL 6 = CALL_HOLD 7 = THREE_WAY_CALL 8 = CALL_TRANSFER 9 = CALLING_NUMBER_DELIVERY 10 = CALLING_NUMBER_DELIVERY_BLOCK 11 = CALL_FORWARD_BUSY 12 = CLASS_OF_SERVICE 13= CALLING_NAME_DELIVERY 14 = CALL_FORWARD_NO_ANSWER 15 = AIN_HANDLING 16 = 911_HANDLING 17 = CUSTOM_DIALING_PLAN 18 = CALLING_ID_DELIVERY_BLOCK_PERM 19 = SFG_INCOMING 20 = SFG_OUTGOING 21 = CANCELLED_CALL_WAITING 22 = USER_SENSITIVE_3WAY_CALL 23 = TOLL_FREE 24 = ACCT_CODE 25 = AUTH_CODE 26 = LOCAL_NUMBER_PORTABILITY 27 = CALLER_IDENTITY_DELIVERY_SUSPENSION 28 = CALLING_NAME_DELIVERY_BLOCKING 29 = CALL_WAITING_WITH_CALLER_IDENTITY 30 = ANONYMOUS_CALL_REJECTION 31 = TOLL_FREE_CALL 32 = CUSTOMER_ORIGINATED_TRACE 33 = CALL_PARK 34 = CALL_PARK_RETRIEVAL 35 = CALL_PARK_REOFFERED 36 = DIRECTED_CALL_PICKUP WITH BARGE-IN 37 = DIRECTED_CALL_PICKUP WITHOUT BARGE-IN 38 = HOTLINE 39 = WARMLINE
	Service Type 1 (continued)	Numeric		40= BUSY_LINE_VERIFICATION	Class name of the first service invoked in call. If this field is a value of ZERO, then no data was captured for this record.
				41 = SELECTIVE_CALL_REJECTION 42 = SELECTIVE_CALL_FORWARDING 43 = SELECTIVE_CALL_ACCEPTANCE 44 = AUTOMATIC_CALLBACK 45 = AUTO_RECALL 46 = SPEED_CALLING 47 = DO_NOT_DISTURB 48 = REMOTE_ACTIVATION OF CALL_FORWARDING 49 = REMOTE_ACTIVATION OF CALL_FORWARDING PIN 50 = DRCW DISTINCTIVE_RING_CALL_WAITING 51 = SCREENING_LIST_EDIT SCF 52 = SCREENING_LIST_EDIT SCA 53 = SCREENING_LIST_EDIT SCR 54 = SCREENING_LIST_EDIT DRCW 55 = REJECT_CALLER 56 = CALL WAITING DELUXE 57 = THREE WAY CALL DELUXE 58 = OUTGOING CALL BARRING 59 = HOTLINE VARIABLE 60 = CNAM SCP Query 61 = REFER 67 = LCD PREPAID (FUTURE) 68 = POSTPAID (FUTURE)
30	Service Type 2	Numeric		(same as Service Type 1 above)	The class name of the second service invoked within the call.
31	Service Type 3	Numeric		(same as Service Type 1 above)	The class name of the third service invoked within the call.
32	Feature Data 1	String	30	See "Feature Server Derived Call Data" for specifics on feature data.	Feature specific data provided by the associated Feature Server for the Service Type 1 of a call. If this field is NULL, then no data was captured for this record.
33	Feature Data 2	String	30	See "Feature Server Derived Call Data" for specifics on feature data.	Feature specific data provided by the associated Feature Server for the Service Type 2 of a call. If this field is NULL, then no data was captured for this record.
34	Feature Data 3	String	30	See "Feature Server Derived Call Data" for specifics on feature data.	Feature specific data provided by the associated Feature Server for the Service Type 3 of a call. If this field is NULL, then no data was captured for this record.
35	Authorization Code	String	25	DIGITS	Authorization code information. If this field is NULL, then no data was captured for this record.
36	Account Code	String	15	DIGITS	Account code information. If this field is NULL, no data was captured for this record.
37	Database Query Type1	Numeric		0 = RESERVED (null) 1 = TOLL_FREE_ LOCAL 2 = TOLL_FREE_SCP 3 = LNP	Indicator of the specific type of 800 or LNP query performed on the first database query for the call. If this field is a value of NULL, then no data was captured for this record.
38	Database Query Result Code1	Numeric		1 = SUCCESS 2 = FAILURE	Indication of the disposition of the first database query for the call. If this field is a value of NULL, then no data was captured for this record.
39	Returned Number 1	String	128	DIGITS	Directory number returned from the first database query for the call. If this field is NULL, then no data was captured for this record. CAVEAT: If this field contains a character that coincides with the character specified as the field or record delimiter for the Cisco BTS 10200 billing records, it is replaced with a SPACE character to ensure the integrity of the billing data.
40	MLH Centrex Group Name	String	16	ASCII characters	Identity of the multi-line hunt group (MLHG) or Centrex group that this call is associated with. If this field is NULL, then no data was captured for this record.
41	Called Party Off Hook Indicator	Numeric		0 = NO 1 = YES	Indication that the terminating party went off-hook. If this field is NULL, then no data was captured for this record.
42	Called Party Short Off Hook Indicator	Numeric		0 = NO 1 = YES	Indication that the called party was off-hook for less than two seconds. If this field is NULL, then no data was captured for this record.
43	Call Termination Cause	Numeric		See Appendix C, "Release Cause Codes," in the Cisco BTS 10200 Operations, Maintenance, and Troubleshooting Guide.	The reason the call was released. If this field is a value of NULL, then no data was captured for this record.
44	Operator Action	Numeric		0 = AUTO_IDENTIFIED_ CUSTOMER_DIALED 1 = AUTO_IDENTIFIED_ OPERATOR_DIALED 2 = OPER_IDENTIFIED_ CUSTOMER_DIALED 3 = OPER_IDENTIFIED_ OPERATOR_DIALED	Operator action with respect to the originating party: automatically identified— customer dialed (0) or operator dialed (1) or operator identified— customer dialed (2) or operator dialed (3) If this field is NULL, then no data was captured for this record.
45	Originating Signaling Type	Numeric		0 = LINE (MGCP) 1 = SS7 2 = ISDN 3 = CAS 4 = MGCP 5 = SIP 6 = H323	Denotes trunk type of originator. If this field is NULL, then no data was captured for this record.
46	Termination Signaling Type	Numeric		0 = LINE (MGCP) 1 = SS7 2 = ISDN 3 = CAS 4 = MGCP 5 = SIP 6 = H323	Denotes trunk type of terminator. If this field is NULL, then no data was captured for this record.
47	Originating Trunk Number	Numeric		32 bit unsigned integer in the range of 1- 99999999	Identity of the originating trunk. It is recommended the upper end of this range be limited to 9999 when converting these records to BAF AMA format for compatibility. If this field is a value of NULL, then no data was captured for this record.
48	Terminating Trunk Number	Numeric		32 bit unsigned integer in the range of 1- 99999999	Identity of the terminating trunk. It is recommended the upper end of this range be limited to 9999 when converting these records to BAF AMA format for compatibility. If this field is a value of NULL, then no data was captured for this record.
49	Outgoing Trunk Number	Numeric		16 bit unsigned integer	The outgoing trunk is on the network facing side of the access tandem. When a call is terminated to the access tandem it is over a generic trunk group and the TNS is passed, and, based on the TNS, the access tandem will select the trunk for routing, for example 0288 will select an AT&T trunk. The access tandem then sends an exit message back with the trunk number from the network facing side. That is the number that appears in this field. If this field is a value of ZERO, then no data was captured for this record.
50	Carrier Identification Code	String	5	DIGITS	Identification of the carrier that transported the call, either an inter-exchange carrier or an international carrier. This value is typically 3- or 4-digits, not necessarily 5-digits. If this field is NULL, then no data was captured for this record.
51	Originating Circuit Identifier			16 bit unsigned integer in the range of 0 - 16383	This field is used to represent the Circuit Id of Inc ISUP trunk. If this field is a value of NULL, then no data was captured for this record.
52	Terminating Circuit Identifier	Numeric		16 bit unsigned integer in the range of 0 - 16383	This field is used to represent the Circuit Id of Outgoing ISUP trunk. If this field is a value of NULL, then no data was captured for this record.
53	PIC Source	Numeric		1 = PIC_DIALED 2 = PIC_DEFAULT	Indication of how the carrier's access code was entered—dialed or via PIC. If this field is a value of NULL, then no data was captured for this record.
54	Inter-exchange carrier or international carrier indicator	Numeric		0 = CIC_FGD_OPERATOR_ INVOLVED 1 = CIC_FGD_OPERATOR_ NOT_INVOLVED 2 = CIC_FGD_OPERATOR_ INVOLVED_UNKNOWN 7 = CIC_UNKNOWN_OPERATOR_ INVOLVED 8 = CIC_UNKNOWN_OPERATOR_ NOT_INVOLVED 9 = CIC_UNKNOWN_OPERATOR_ INVOLVED_UNKNOWN	Describes operator involvement: FGD CIC with (1) operator involvement, (2) dialed direct with no operator, (3) with undetermined operator involvement, or unknown CIC with (1) operator involvement, (2) dialed direct with no operator, or (3) undetermined operator involvement. Note This field is applicable only in calls interconnected to other carriers. If this field is NULL, then no data was captured for this record.
55	Inter-exchange carrier or international carrier Event Status Indicator	Numeric		Call is abandoned or release before IAM is sent by originating EC = 15 Call is abandoned or release after IAM is received by originating EC = 20	Indication of how far a call has progressed before terminating when an IC/INC is involved. Note This field is only applicable to SS7 calls that are interconnected to another carrier. If this field is a value of NULL, then no data was captured for this record.
56	Inter-exchange carrier or international carrier Routing Indicator	Numeric		0 = DIRECT 1= TANDEM 2 = CAP_ENDOFFICE 3 = CAP_TANDEM 4 = TANDEM_TSP	Describes how the call was routed to/from the IC/INC: EAEO direct to IC/INC, or EAEO via AT to INC/IC, or CAP direct from EO, or CAP direct from AP tandem. Note This field is applicable only in calls interconnected to other carriers. If this field is NULL, then no data was captured for this record.
57	Orig Quality of Service Packets Sent	Numeric		32 bit unsigned value	Number of packets sent over bearer path for duration of call reported by media gateway. If this field is NULL, then no data was captured for this record.
58	Orig Quality of Service Packets received	Numeric		32 bit unsigned value	Number of packets received over bearer path for duration of call reported by media gateway. If this field is NULL, then no data was captured for this record.
59	Orig Quality of Service Octets Sent	Numeric		32 bit unsigned value	Number of octets sent over bearer path for duration of call reported by media gateway. If this field is NULL, then no data was captured for this record.
60	Orig Quality of Service Octets Received	Numeric		32 bit unsigned value	Number of octets received over bearer path for duration of call reported by media gateway. If this field is NULL, then no data was captured for this record.
61	Orig Quality of Service Packets Lost	Numeric		32 bit unsigned value	Number of packets lost over bearer path for duration of call reported by media gateway. If this field is NULL, then no data was captured for this record.
62	Orig Quality of Service Jitter	Numeric		32 bit unsigned value	Amount of jitter over bearer path for duration of call reported by media gateway. If this field is NULL, then no data was captured for this record.
63	Orig Quality of Service Average Latency	Numeric		32 bit unsigned value	Average latency over bearer path for duration of call reported by media gateway. If this field is NULL, then no data was captured for this record.
64	Term Quality of Service Packets Sent	Numeric		32 bit unsigned value	Number of packets sent over bearer path for duration of call reported by media gateway. If this field is NULL, then no data was captured for this record.
65	Term Quality of Service Packets received	Numeric		32 bit unsigned value	Number of packets received over bearer path for duration of call reported by media gateway. If this field is NULL, then no data was captured for this record.
66	Term Quality of Service Octets Sent	Numeric		32 bit unsigned value	Number of octets sent over bearer path for duration of call reported by media gateway. If this field is NULL, then no data was captured for this record.
67	Term Quality of Service Octets Received	Numeric		32 bit unsigned value	Number of octets received over bearer path for duration of call reported by media gateway. If this field is NULL, then no data was captured for this record.
68	Term Quality of Service Packets Lost	Numeric		32 bit unsigned value	Number of packets lost over bearer path for duration of call reported by media gateway. If this field is NULL, then no data was captured for this record.
69	Term Quality of Service Jitter	Numeric		32 bit unsigned value	Amount of jitter over bearer path for duration of call reported by media gateway. If this field is NULL, then no data was captured for this record.
70	Term Quality of Service Average Latency	Numeric		32 bit unsigned value	Average latency over bearer path for duration of call reported by media gateway. If this field is NULL, then no data was captured for this record.
71	Operator Involvement	Numeric		0 = NO, 1 = YES	Determines if operator is involved in the call for 0-, 0+, or 01+. If this field is NULL, then no data was captured for this record.
72	Casual Dialing	Numeric		0 = NO, 1 = YES	Determines whether it is a casual call (CIC) or PIC call. If this field is NULL, then no data was captured for this record.
73	Connection Type	Numeric		0 = IP 1 = HAIRPIN 3 = ATM SVC 4 = ATM PVC	Type of connection gateway is making so the reader of the record will know why the QoS parameters are different than expected. For example, if a Hairpin connection is used, then the QoS will be zeros. If this field is NULL, then no data was captured for this record.
74	Packet Time	Numeric		8 bit unsigned value	Packetization period for voice sampling. If this field is a value of NULL, then no data was captured for this record.
75	Silence Suppression	Numeric		0 = NO, 1 = YES	Indicates if silence suppression is enabled or not. If this field is NULL, then no data was captured for this record.
76	Echo Cancellation	Numeric		0 = NO, 1 = YES	Indicates if echo cancellation at far end is enabled or not. If this field is NULL, then no data was captured for this record.
77	Codec Type	Numeric		1= PCMU G711 2 = PCMA G711 3 = G729A 4 = G729B 5 = G729E 6 = G729 7 = G726-40 8 = G726-32 9 = G726-24 10 = G726-16 11 = G728 12 = G723-H 13 = G723A-H 14 = G723-L 15 = G723A-L 16 = G723	Codec used to transport RTP traffic. If this field is a value of NULL, then no data was captured for this record.
78	Interstate Indicator	Numeric		0 = NO, 1 = YES	Indicates whether call crossed a state boundary or not. If this field is NULL, then no data was captured for this record.
79	Record Type	Numeric		0 = NORMAL_RECORD 1 = FIRST_LONG_DURN_RECORD 2 = CONTINUATION_ LONG_DURN_RECORD 3 = LAST_LONG_DURN_RECORD 4 = INVALID_RECORD	Indicates whether record is involved in long duration call accounting or not. If this field is NULL, then no data was captured for this record.
80	Timer Indicator	Numeric		1 = FIRST 2 = CONTINUATION	Type of long duration record. If this field is a value of NULL, then no data was captured for this record.
81	Present Time	Numeric		32 bit unsigned value in GMT epoch time format. The number of seconds since Jan 1,1970 0:00:00h. If the value is NULL, the timestamp is to be ignored.	Time the continuation record was created.
82	Overall Correlation Identifier	String	25	Alphanumeric characters	This field is unique on a per call scenario basis; not on a per record basis. Any call scenario that results in multiple call records being generated by the Cisco BTS 10200, each will contain the same value in this field. The main use at this time is within the real time Event Message billing stream that is supported by the BTS for PacketCable compliancy and for correlation of multiple record call scenarios. This field should always be populated.
83	JIP	String	10	Alphanumeric characters	Jurisdiction information parameter used for tarriffing purposes. If this field is NULL, then no data was captured for this record.
84	Originating CLLI	String	11	Alphanumeric characters	Trunk Group Name for originating call leg. If this field is NULL, then no data was captured for this record.
85	Terminating CLLI	String	11	Alphanumeric characters	Trunk Group Name for terminating call leg. If this field is NULL, then no data was captured for this record.
86	Call Agent Id	String	8	Alphanumeric characters	Identifies Call Agent on which CDB is created. If this field is NULL, then no data was captured for this record.
87	Originating POP Time Zone	Numeric		Refer to "Time Zone Mapping Table," for the potential values.	This is the point of presence that the originating subscriber on the Cisco BTS 10200 is provisioned into. This field provides information on the locale to which the subscriber is a member. This information can also be leveraged for partitioning subscribers on a single Cisco BTS 10200 into multiple business entities for billing purposes. If this field is NULL, then no data was captured for this record.
88	Service Usage Sensitive 1	Numeric		0 = FALSE, 1 = TRUE Note This field is applicable only if Service Type 1 field is populated.	Indication of whether first service usage within the call context was usage sensitive or not. If this field is NULL, then no data was captured for this record.
89	Service Usage Sensitive 2	Numeric		0 = FALSE, 1 = TRUE Note This field is applicable only if Service Type 2 field is populated.	Indication of whether second service usage within the call context was usage sensitive or not. If this field is NULL, then no data was captured for this record.
90	Service Usage Sensitive 3	Numeric		0 = FALSE, 1 = TRUE Note This field is applicable only if Service Type 3 field is populated.	Indication of whether third service usage within the call context was usage sensitive or not. If this field is NULL, then no data was captured for this record.
91	Originating H323 Call Origin	Numeric		0 = NULL 1 = ANSWER 2 = ORIGINATE	ANSWER indicates call terminated on reporting gateway. ORIGINATE indicates call was outbound from reporting gateway for originating half of call. Note This field is populated only for calls over an H.323 network. If this field is a value of NULL, no data was captured for this record.
92	Originating H323 Call Type	Numeric		1 = VOIP 2 = TELEPHONY 3 = VIDEO	Value indicates protocol family used on originating leg of the call. Note This field is populated only for calls over an H.323 network. If this field is a value of NULL, no data was captured for this record.
93	Originating H323 Conference Id	String	32	Alphanumeric characters.	Unique identifier generated by originating PSTN gateway for each unique call scenario within a given call context. Note This field is populated only for calls over an H.323 network. If this field is NULL, no data was captured for this record.
94	Originating H323 Remote Address	String	16	Alphanumeric characters.	IP address of originating remote gateway. Note This field is populated only for calls over an H.323 network. If this field is NULL, no data was captured for this record.
95	Originating H323 Time Day	Numeric		32 bit unsigned value in GMT epoch time format. The number of seconds since Jan 1,1970 0:00:00h. If the value is zero, the timestamp is to be ignored.	Time of day terminating number was dialed for originating half of call. Note This field is populated only for calls over an H.323 network.
96	Originating H323 Voice Quality	Numeric		This field is not populated for this release.	Quality of voice connection for originating side of call. This is a decimal number from the ICPIF table of G.113.
97	Originating H323 Subscriber	Numeric		This field is not populated for this release.	Subscriber T1/CAS signaling information from originating side of call.
98	Originating H323 Gateway Id	String	16	Alphanumeric characters.	For incoming calls from an H.323 network, this field will contain the h323-id of the originating (far end) H.323 gateway/endpoint. If this parameter is not available in the incoming H.323 call, the Cisco BTS 10200 will populate this field with local h323-id from the H.323-GW that received the call. For incoming calls from non-H.323 networks, this field is NULL. Note This field is only populated for calls over an H.323 network. If this field is NULL, no data was captured for this record.
99	Originating H323 Gatekeeper Id	String	16	Alphanumeric characters.	The hostname of the originating primary gatekeeper for the call. Note This field is only populated for calls over an H.323 network. If this field is NULL, no data was captured for this record.
100	Terminating H323 Call Origin	Numeric		0 = NULL 1 = ANSWER 2 = ORIGINATE	ANSWER indicates the call terminated on the reporting gateway ORIGINATE indicates the call was outbound from the reporting gateway for the terminating half of the call. Note This field is only populated for calls over an H.323 network. If this field is a value of NULL, no data was captured for this record.
101	Terminating H323 Call Type	Numeric		1 = VOIP 2 = TELEPHONY 3 = VIDEO	Indication of the protocol family used on the terminating leg of the call. Note This field is only populated for calls over an H.323 network. If this field is a value of NULL, no data was captured for this record
102	Terminating H323 Conference Id	String	32	Alphanumeric characters.	A unique identifier generated by the terminating PSTN gateway for each unique call scenario within a given call context. Note This field is only populated for calls over an H.323 network. If this field is NULL, no data was captured for this record.
103	Terminating H323 Remote Address	String	16	Alphanumeric characters.	The IP address of the terminating remote gateway. Note This field is only populated for calls over an H.323 network. If this field is NULL, no data was captured for this record.
104	Terminating H323 Time Day	Numeric		32 bit unsigned value in GMT epoch time format. The number of seconds since Jan 1,1970 0:00:00h. If the value is NULL, the timestamp is to be ignored.	The time of day that the terminating number was dialed for the terminating half of the call. Note This field is populated only for calls over an H.323 network.
105	Terminating H323 Voice Quality	Numeric		This field is not populated for this release.	The quality of voice connection for the terminating side of the call. This is a decimal number from the ICPIF table of G.113. If this field is a value of NULL, no data was captured for record.
106	Terminating H323 Subscriber	Numeric		This field is not populated for this release.	Subscriber T1/CAS signaling information from terminating side of call. If this field is a value of NULL, no data was captured for this record.
107	Terminating H323 Gateway Id	String	16	Alphanumeric characters.	For outgoing calls from Cisco BTS 10200 and terminating to an H.323 network, this field will contain h323-Id of the terminating (far end) H.323 gateway/endpoint if available in backward Call signaling message. If this parameter is not available from terminating H.323 Gateway/endpoint Cisco BTS 10200 will populate the local h323-id from H323-GW which is used to send out the call. For outgoing calls to no H.323 network, this field is NULL. Note This field is populated only for calls over an H.323 network. If this field is NULL, no data was captured for this record.
108	Terminating H323 Gatekeeper Id	String	16	Alphanumeric characters.	The symbolic host name assigned to the terminating primary gatekeeper for the call. Note This field is populated only for calls over an H.323 network. If this field is NULL, no data was captured for this record.
109	Orig Type	Numeric		0 = ON NET 1 = OFF NET	Indication of whether call was originated by a subscriber homed on the reporting Cisco BTS 10200 Softswitch. If this field is NULL, then no data was captured for this record.
110	Term Type	Numeric		0 = ON NET 1 = OFF NET	Indication of whether call was terminated by subscriber homed on the reporting Cisco BTS 10200 Softswitch.
111	Source Service Provider Id	String	16	Alphanumeric characters	This field contains the network provided or Service Provider Identifier configured for incoming calls to the Cisco BTS 10200. For incoming calls from the PSTN network, this field contains the service provider ID value after finding a matching entry in the CARRIER table for the TNS/CIP parameter against the Carrier ID. For incoming calls from an H.323 network, this field contains the value in the field "circuitInfo.destinationCircuitId" (H323v4) or Service Provider ID derived from tech-prefix received in the SETUP message. When this parameter does not exist in the SETUP message, the service provider ID configured for the incoming trunk group will be used to populate this field. When source based routing is enabled, the Cisco BTS 10200 selects the trunk group based on the source IP address and circuitInfo.sourceCircuitId field from the SETUP message received. When the circuitInfo.destinationCircuitId does not match the service provider ID configured on the incoming trunk group, the call is routed using the default route. If this field is NULL, then no data was captured for this record.
112	Destination Service Provider Id	String	16	Alphanumeric characters	This field contains the identifier of the destination service provider which is used to route the call. For outgoing calls to an H.323 network, this field is populated with destinationCarrierId from the IZCT (Intra Zone Clear Token) parameter of the ACF message returned by the outgoing Gatekeeper. If this value is not received from the Gatekeeper, the value provisioned in the service provider ID of the outgoing trunk group is used. For outgoing calls to the PSTN network, this field is populated with a value of the service provider ID provisioned in the outgoing trunk group. If this field is NULL, then no data was captured for this record.
113	Source Carrier Id	String	4	Numeric characters	This field contains a 4-digit value form the Transit Network Selection (TNS) or Carrier Identification code Parameter (CIP) parameter of the IAM/SETUP message received from the PSTN network. If TNS or CIP is not received, this field is populated with the Carrier ID field provisioned in the incoming trunk group. This field is only applicable to tandem call scenarios. If this field is NULL, then no data was captured for this record.
114	Destination Carrier Id	String	4	Numeric characters	This field contains the 4-digit carrier ID of the outgoing trunk group used to route the call. For calls routed to the PSTN network, this field contains the value provisioned into the Carrier ID field of the trunk group table. If this field is NULL, then no data was captured for this record.
115	Originating SIP Username	String	64	Alphanumeric characters.	MSN PUID from Proxy Authorization header field for all MSN calls. Username value of From field for all other SIP calls. Note This field is populated only for SIP calls. If this field is NULL, no data was captured for this record.
116	Originating SIP Call Id	String	64	Alphanumeric characters.	SIP Call Id header field. This field is a truncation of SIP Call Id header field received via SIP if it is over 64 characters in length. Note This field is populated only for SIP calls. If this field is NULL, no data was captured for this record.
117	Originating SIP Adjacent Hop Address	String	16	Alphanumeric characters.	IP address of last proxy that forwarded calls inbound to Cisco BTS 10200 Softswitch. IP address of proxy to which outbound calls from the Cisco BTS 10200 are forwarded. Note This field is only populated for SIP calls. If this field is NULL, no data was captured for this record.
118	Database Query Time 2	Numeric		32 bit unsigned value in GMT epoch time format. The number of seconds since Jan 1,1970 0:00:00h.	Time the second database query response was received for this call. If the value is NULL, timestamp is ignored.
119	Database Query Result Code 2	Numeric		1 = SUCCESS 2 = FAILURE	Indicates disposition of the second database query for call. If this field is a value of NULL, no data was captured for this record.
120	Database Query Type2	Numeric		1 = TOLL_FREE_ SCP 2 = TOLL_FREE_LOCAL 3 = LNP 4 = CNAM_SCP	Indicates specific type of 800 or LNP query performed on second database query for call. If this field is a value of ZERO, no data was captured for this record.
121	Returned Number 2	String	128	DIGITS, DIGITS	The directory number returned from the second database query for the call. If field is NULL, no data was captured for this record. CAVEAT: If this field is found to contain a character coinciding with the character specified as the field or record delimiter for the Cisco BTS 10200 billing records, it is replaced with a SPACE character to ensure the integrity of the billing data.
122	Database Query Time 3	Numeric		32 bit unsigned value in GMT epoch time format. The number of seconds since Jan 1,1970 0:00:00h. If the value is NULL, the timestamp is to be ignored.	The time the third database query response was received for this call.
123	Database Query Result Code 3	Numeric		1 = SUCCESS 2 = FAILURE	Indicates disposition of third database query for call. If this field is a value of NULL, no data was captured for this record.
124	Database Query Type 3	Numeric		1 = TOLL_FREE_ SCP 2 = TOLL_FREE_LOCAL 3 = LNP 4 = CNAM_SCP	Indicates specific type of 800 or LNP query performed on the third database query for the call. If this field is a value of NULL, no data was captured for this record.
125	Returned Number 3	String	128	DIGITS, DIGITS	Directory number returned from third database query for call. If this field is NULL, no data was captured for this record.
126	Service Result Code1	Numeric		1 = SUCCESS 2 = FAILURE 3 = ANI INVALID 4 = ANI BLOCKED 5 = CASUAL CALLS NOT ALLOWED 6 = II SCREENING REJECT 7 = BW SCREENING REJECT 8 = COS RESTRICTED	Indicates disposition of first service activation, service deactivation, or service instance within the call context. Note This field is applicable only if the Service Type 1 field is populated. If this field is a value of NULL, no data was captured for this record.
127	Service Result Code2	Numeric		(same as Service Result Code 1)	Indicates disposition of second service activation, service deactivation, or service instance within the call context. Note This field is applicable only if the Service Type 2 field is populated. If this field is a value of NULL, no data was captured for this record
128	Service Result Code3	Numeric		(same as Service Result Code 1)	Indicates disposition of third service activation, service deactivation, or service instance within the call context. Note This field is applicable only if the Service Type 3 field is populated. If this field is a value of NULL, no data was captured for this record
129	NAS Error Code	Numeric		800 = ISP PORT LIMIT           OVERRUN 801 = NO MODEMS AVAILABLE 802 = ORIGINATING NUMBER           UNACCEPTABLE 803 = TERMINATING NUMBER           UNACCEPTABLE	Specific error code explaining reason that this NAS call could not be completed. If this field is a value of NULL, no data was captured for this record.
130	NAS DLCX Reason	Numeric		801 = USER REQUEST 802 = LOST CARRIER 803 = LOST SERVICE 804 = IDLE TIMEOUT 805 = SESSION TIMEOUT 806 = ADMIN RESET 807 = ADMIN REBOOT 808 = PORT ERROR 809 = NAS ERROR 810 = NAS REQUEST 811 = NAS REBOOT 812 = PORT UN-NEEDED 813 = PORT PRE-EMPTED 814 = PORT SUSPENDED 815 = SERVICE UNAVAILABLE 816 = CALLBACK 817 = USER ERROR 818 = HOST REQUEST	Reason code returned in the DLCX message for NAS calls. If this field is a value of NULL, no data was captured for this record.
131	NAS Pre-Authorization Result	Numeric		0 = NULL 1 = AU—EVERYTHING IS OK 2 = AX—CGN/CDN NUMBERS       ARE NOT GOOD 3 = OF—MODEM FAILURE	Indicates result of performing pre-authorization on a NAS-based call. If this field is a value of NULL, no data was captured for this record.
132	Fax Indicator	Numeric		1= NOT FAX 2 = FAX ONLY 3 = VOICE AND FAX	Indication of whether the call involved any fax transmissions. Value of 1 (Not Fax) indicates no fax transmissions occurred, the other two values indicate faxes were sent or received. If this field is a value of NULL, no data was captured for this record.
133	Fax Pages Sent	Numeric		The range of values is 0 - 999.	Number of fax pages sent during call. If this field is a value of NULL, no data was captured for this record.
134	Fax Pages Received	Numeric		The range of values is 0 - 999.	Number of fax pages received during call. If this field is a value of NULL, no data was captured for this record.
135	Service Interrogation Time 1	Numeric		32 bit unsigned value in GMT epoch time format. The number of seconds since Jan 1,1970 0:00:00h. If the value is NULL, the timestamp is to be ignored.	The time the interrogation of Service Type 1 occurred.
136	Service Interrogation Time 2	Numeric		32 bit unsigned value in GMT epoch time format. The number of seconds since Jan 1,1970 0:00:00h. If the value is NULL, the timestamp is to be ignored.	The time the interrogation of Service Type 2 occurred.
137	Service Interrogation Time 3	Numeric		32 bit unsigned value in GMT epoch time format. The number of seconds since Jan 1,1970 0:00:00h. If the value is NULL, the timestamp is to be ignored.	The time the interrogation of Service Type 3 occurred.
138	Originating Pop Id	String	16	Alphanumeric characters	This is the point of presence that the originating subscriber on the BTS is provisioned on. This field provides information on the locale of which the subscriber is a member. This information can also be leveraged for partitioning subscribers on a single BTS into multiple business entities for billing purposes. If this field is NULL, no data was captured for this record.
139	Terminating Pop Id	String	16	Alphanumeric characters	This is the point of presence that the terminating subscriber on the BTS is provisioned on. This field provides information on the locale of which the subscriber is a member. This information can also be leveraged for partitioning subscribers on a single BTS into multiple business entities for billing purposes. If this field is NULL, no data was captured for this record.
140	Terminating POP Time Zone	Numeric		Refer to "Time Zone Mapping Table," for the potential values.	This is the point of presence that the originating subscriber on the Cisco BTS 10200 is provisioned into. This field provides information on the locale to which the subscriber is a member. This information can also be leveraged for partitioning subscribers on a single Cisco BTS 10200 into multiple business entities for billing purposes. If this field contains a value of NULL, then there is no information stored in this field for this record.
141	Dial Plan Id	String	16	Alphanumeric characters.	Dial plan used for call routing purposes by originating subscriber on Cisco BTS 10200. The dial plan defines valid digit patterns for the subscriber in addition to routing based on the dialed digits. If this field is NULL, no data was captured for this record.
142	GTD Global Call Indicator	String	32	Alphanumeric characters inclusding hyphens.	GTD Global Call Identification field populated only for H.323 calls with GTD enabled. The Cisco BTS 10200 will use the GCI format consistent with the IOS GTD implementation, which is in the form of a 16-character ASCII representation of a UTC timestamp followed by a 4-character ASCII representation of the clock sequence, plus a 12-character ASCII representation of the MAC address This field will always be in the length of 32 characters. If this field is NULL, no data was captured for this record.
143	Terminating SIP Username	String	64	Alphanumeric characters.	The username value of the "From" field on the terminating side for all outgoing SIP calls. This field is populated only for SIP calls. If this field is NULL, no data was captured for this record.
144	Terminating SIP Call Id	String	64	Alphanumeric characters.	The SIP Call ID header field. This field is a truncation of the SIP Call ID header field received via SIP if it is over 64 characters in length. This field is populated only for outgoing SIP calls. If this field is NULL, no data was captured for this record.
145	Terminating SIP Adjacent Hop Address	String	16	Alphanumeric characters	The IP address of the proxy or SIP User Agent that the call is sent to for calls outbound from the BTS. This field is only populated for outgoing SIP calls. If this field is NULL, then no data was captured for this record.
146	Originating SIP Type	Numeric		SUBSCRIBER = 1 SIP = 2 SIP-T = 3 CMSS = 4	The type of SIP call on the inbound side. This field is only populated for SIP originations. If this field is a value of NULL, no data was captured for this record.
147	Terminating SIP Call Type	Numeric		SUBSCRIBER = 1 SIP = 2 SIP-T = 3 CMSS = 4	The type of SIP call on the outbound side. This field is only populated for SIP terminations. If this field is a value of NULL, no data was captured for this record.
148	Originating H.323 Network Provider Id	String	16	Alphanumeric characters.	This field contains the value contained in the IZCT source zone parameter of the ACF message for the outgoing call leg. If this field is NULL, then no data was captured for this record.
149	Destination H.323 Network Provider Id	String	16	Alphanumeric characters.	This field contains the identifier of the destination service provider which is used by external route servers to route the call to the final destination. This field is only applicable for outgoing calls to an H.323 network. This field contains the IntermediateCarrierId field from the IZCT parameter of the ACF message received from the outgoing Gatekeeper. If this field is NULL, then no data was captured for this record.
150	Video codec	Numeric		None = 0 (future) H.261 = 1 (future) H.263 = 2 (future) H.264 = 3 (future) This field is always zero in Release 4.4	The codec used to transport the RTP traffic. The value in this field is pulled from the provisioning of the Cisco BTS 10200 Softswitch, not from the actual SDP message.
151	Original Originating Number	String	64	DIGITS	This field contains the calling number received in the SETUP Message after digit manipulation is performed but before any overriding occurs—such as overwriting with a billing dn. If this field is NULL, then no data was captured for this field.
152	Calling Party Category	Numeric		Unknown = 0 National Operator = 9 Ordinary Subscriber = 10 Subscriber w/Priority = 11 Voice Band Data = 12 Test Call = 13 Pay Phone = 15 Line Test Desk = 249 Interception Operator = 250 Immediate Charge Info = 251	The Calling Party Category value that was received in the SS7 IAM. If this field is NULL, then no data was captured for this record.
153	Called Party Category Indicator	Numeric		No Indication = 0 Ordinary Subscriber = 1 Payphone = 2	The Called Party Category Indicator value is derived from the FE bits of the Backward Call Indicator received via SS7. If this field is NULL, then no data was captured for this record.