| batch_dura |
int |
Accumulated Duration (second) for this Batch |
| batch_hold |
int |
Accumulated Hold Time (second) for this Batch |
| batch_tim_ans |
varchar |
Answer Time for this Batch |
| batch_tim_beg |
varchar |
Start Time for this Batch |
| by_action |
varchar |
3rd Party - Action |
| by_callid |
varchar |
3rd Party - SIP's Call-ID |
| by_domain |
varchar |
3rd Party - Domain |
| by_id |
varchar |
3rd Party - Circuit ID |
| by_sub |
varchar |
3rd Party - User |
| by_uri |
varchar |
3rd Party - URI |
| cdr_index |
int |
Batch Index |
| codec |
varchar |
Audio Codec |
| disposition |
varchar |
Disposition - Classification |
| duration |
int |
Total duration from Answer to Hangup in second |
| image_cnt_a |
varchar |
Fax Relay Receive Byte Count - A Side |
| image_cnt_b |
varchar |
Fax Relay Receive Byte Count - B Side |
| image_codec |
varchar |
Fax Codec |
| image_prt_0 |
varchar |
Fax Relay Local Port |
| image_prt_a |
varchar |
Fax Relay Remote Port - A Side |
| image_prt_b |
varchar |
Fax Relay Remote Port - B Side |
| notes |
text |
Disposition - Note |
| orig_callid |
varchar |
Origination SIP's Call-ID |
| orig_domain |
varchar |
Origination Domain |
| orig_from_host |
varchar |
Host component in "orig_from_uri" |
| orig_from_name |
varchar |
Display Name in "orig_from_uri" |
| orig_from_uri |
varchar |
From-URI in Origination INVITE |
| orig_from_user |
varchar |
User component in "orig_from_uri" (ANI) |
| orig_id |
varchar |
Origination Circuit ID |
| orig_ip |
varchar |
Origination IP |
| orig_logi_uri |
varchar |
Logical Origination URI |
| orig_match |
varchar |
Match Pattern used to identify the Origination Device/Connection |
| orig_req_host |
varchar |
Host component in "orig_req_uri" |
| orig_req_uri |
varchar |
Request URI in Origination INVITE |
| orig_req_user |
varchar |
User component in "orig_req_uri" |
| orig_sub |
varchar |
Origination User |
| orig_to_host |
varchar |
Host component in "orig_to_uri" |
| orig_to_uri |
varchar |
To-URI in Origination INVITE |
| orig_to_user |
varchar |
User component in "orig_to_uri" (DNIS) |
| pac |
varchar |
Account Code |
| reason |
varchar |
Disposition - Reason |
| release_code |
varchar |
Batch Marker: begin, continue or end |
| release_text |
varchar |
Reason for Call Release |
| rly_cnt_a |
varchar |
Audio Relay Receive Byte Count - A Side |
| rly_cnt_b |
varchar |
Audio Relay Receive Byte Count - B Side |
| rly_prt_0 |
varchar |
Audio Relay Local Port |
| rly_prt_a |
varchar |
Audio Relay Remote Port - A Side |
| rly_prt_b |
varchar |
Audio Relay Remote Port - B Side |
| route_class |
varchar |
Routing LERG Class |
| route_to |
varchar |
Route Selected |
| term_callid |
varchar |
Termination SIP's Call-ID |
| term_domain |
varchar |
Termination Domain |
| term_id |
varchar |
Termination Circuit ID |
| term_ip |
varchar |
Termination SIP's Call-ID |
| term_logi_uri |
varchar |
Logical Termination URI |
| term_match |
varchar |
Match Pattern used to identify the Termination Device/Connection |
| term_sub |
varchar |
Termination User |
| term_to_uri |
varchar |
Termination To-Uri |
| time_answer |
varchar |
Timestamp of answer (i.e. SIP 200) |
| time_disp |
int |
Time of Disposition |
| time_holding |
int |
Total Hold duration in seconds |
| time_insert |
timestamp |
Time of the last update to this record |
| time_release |
varchar |
Timestamp of disconnect (i.e. SIP BYE) |
| time_ringing |
varchar |
Timestamp of start of ringing (i.e. SIP 18x) |
| time_start |
datetime |
Timestamp of call initiation (i.e. SIP INVITE) |
| time_talking |
int |
Talking Duration in second |
| video_cnt_a |
varchar |
Video Relay Receive Byte Count - A Side |
| video_cnt_b |
varchar |
Video Relay Receive Byte Count - B Side |
| video_codec |
varchar |
Video Codec |
| video_prt_0 |
varchar |
Video Relay Local Port |
| video_prt_a |
varchar |
Video Relay Remote Port - A Side |
| video_prt_b |
varchar |
Video Relay Remote Port - B Side |
