AVAYA DOCUMENTATION CENTER
Find answers to your technical questions and learn how to use our products
No results found
Search suggestions:
- Use fewer tags and filters.
- Use different search terms.
Filters
AVAYA DOCUMENTATION CENTER
Find answers to your technical questions and learn how to use our products
No results found
Search suggestions:
- Use fewer tags and filters.
- Use different search terms.
Filters
Avaya Call Management System Database Items and Calculations
Table of Contents
Type to filter navigation items by title
Trunk database items
Last Updated : Nov 21, 2024 |
Prolog information
Metadata
Keywords:
The Trunk database item descriptions apply to historical items. Historical trunk database items apply to the following tables:
-
Intrahour Trunk (htrunk)
-
Daily Trunk (dtrunk)
-
Weekly Trunk Group (wtrunk)
-
Monthly Trunk (mtrunk)
Unless indicated otherwise, all items listed here are included in all four database tables.
|
Database item
|
Data type
|
Column type
|
Length
|
|---|---|---|---|
|
ABNCALLS
|
C
|
smallint (htrunk)
|
2 bytes
|
|
integer (dtrunk, wtrunk, mtrunk)
|
4 bytes
|
||
|
ACD (index)
|
I
|
smallint
|
2 bytes
|
|
ACDCALLS
|
C
|
smallint (htrunk)
|
2 bytes
|
|
integer (dtrunk, wtrunk, mtrunk)
|
4 bytes
|
||
|
ACDCALLS_R1
|
C
|
smallint (htrunk)
|
2 bytes
|
|
integer (dtrunk, wtrunk, mtrunk)
|
4 bytes
|
||
|
ACDCALLS_R2
|
C
|
smallint (htrunk)
|
2 bytes
|
|
integer (dtrunk, wtrunk, mtrunk)
|
4 bytes
|
||
|
AUDIO
|
C
|
smallint (htrunk)
|
2 bytes
|
|
integer (dtrunk, wtrunk, mtrunk)
|
4 bytes
|
||
|
EQLOC (index)
|
A
|
char(8) - ASCII text string
|
8 bytes
|
|
FAILURES
|
C
|
smallint (htrunk)
|
2 bytes
|
|
integer (dtrunk, wtrunk, mtrunk)
|
4 bytes
|
||
|
I_INOCC
|
C
|
smallint (htrunk)
|
2 bytes
|
|
integer (dtrunk, wtrunk, mtrunk)
|
4 bytes
|
||
|
I_OUTOCC
|
C
|
smallint (htrunk)
|
2 bytes
|
|
integer (dtrunk, wtrunk, mtrunk)
|
4 bytes
|
||
|
ICRPULLCALLS
|
C
|
integer
|
4 bytes
|
|
INCALLS
|
C
|
smallint (htrunk)
|
2 bytes
|
|
integer (dtrunk, wtrunk, mtrunk)
|
4 bytes
|
||
|
INCOMPLETE
|
C
|
smallint
|
2 bytes
|
|
INTIME
|
C
|
smallint (htrunk)
|
2 bytes
|
|
integer (dtrunk, wtrunk, mtrunk)
|
4 bytes
|
||
|
INTRVL
|
A
|
smallint (htrunk only)
|
2 bytes
|
|
LOC_ID
|
A
|
smallint
|
2 bytes
|
|
MBUSYTIME
|
C
|
smallint (htrunk)
|
2 bytes
|
|
integer (dtrunk, wtrunk, mtrunk)
|
4 bytes
|
||
|
O_ABNCALLS
|
C
|
smallint (htrunk)
|
2 bytes
|
|
integer (dtrunk, wtrunk, mtrunk)
|
4 bytes
|
||
|
O_ACDCALLS
|
C
|
smallint (htrunk)
|
2 bytes
|
|
integer (dtrunk, wtrunk, mtrunk)
|
4 bytes
|
||
|
O_OTHERCALLS
|
C
|
smallint (htrunk)
|
2 bytes
|
|
integer (dtrunk, wtrunk, mtrunk)
|
4 bytes
|
||
|
OUTCALLS
|
C
|
smallint (htrunk)
|
2 bytes
|
|
integer (dtrunk, wtrunk, mtrunk)
|
4 bytes
|
||
|
OTHERCALLS
|
C
|
smallint (htrunk)
|
2 bytes
|
|
integer (dtrunk, wtrunk, mtrunk)
|
4 bytes
|
||
|
OUTTIME
|
C
|
smallint (htrunk)
|
2 bytes
|
|
integer (dtrunk, wtrunk, mtrunk)
|
4 bytes
|
||
|
PARTIAL_ARCHIVE
|
I
|
smallint (htrunk only)
|
2 bytes
|
|
ROW_DATE (index)
|
I
|
date - Informix date
|
4 bytes
|
|
SHORTCALLS
|
C
|
smallint (htrunk)
|
2 bytes
|
|
integer (dtrunk, wtrunk, mtrunk)
|
4 bytes
|
||
|
STARTTIME
|
I
|
smallint (htrunk only)
|
2 bytes
|
|
STARTTIME_UTC
|
I
|
integer (htrunk only)
|
4 bytes
|
|
TENANT
|
I
|
integer
|
4 bytes
|
|
TIMEZONE
|
A
|
char(40) - ASCII text string (dtrunk, wtrunk, mtrunk only)
|
40 bytes
|
|
TKGRP (index)
|
A
|
smallint
|
2 bytes
|