Deleting the data

Statistics data stays in the database until you delete it (as described in Managing reports, logs, archives, and statistics online).

Table 1. Explanation of call detail record fields
Position	Keyword	sm_ccr Field	Description
1	`DAT`	TIME_STAMP	The date and time when a call was received or made, expressed as yyyy.mm.dd hh:mm:ss.
2	`SYS`	ASI_NO	A number that identifies the Blueworx Voice Response system.
3	`APP`	FIRST_STBL	For state table applications, the name of the state table that was initially invoked (the top-level state table). For VoiceXML applications, by default, the name of the first VoiceXML dialog (without the `.vxml` suffix, up to a limit of 15 characters). This behavior can be modified to report “JavaApplication” by adding a setting of `dtj.updatecdr=false` to the `dtj.ini` configuration file, or if `dtj.updatecdr` is already present, by changing the the `dtj.updatecdr` setting in the `dtj.ini` configuration file to `false`.
4	`CLT`	IN_CALL	A one-character code indicating whether a call was inbound (1) or outbound (0).
5	`CDN`	CALLED_NO	A 19-character field containing the called number.
6	`CGN`	CALLING_NO	A 19-character field containing the calling number.
7	`CLD`	DURATION	Call duration in seconds. This is the length of time that elapses from when the caller or called party is connected to a voice application until either the application or the caller hangs up.
8	`CSD`	SETUP_TIME	Call setup duration in seconds. This is the length of time that elapses from the detection of an incoming call until the caller is connected to a voice application, or the time that elapses from the beginning of outbound dialing until the called party answers.
9	`TNK`	TRUNK_NO	The trunk that processed the call.
10	`CHN`	LINE_NO	The physical channel on which the call was handled.