Trunk Group database items

Last Updated : Nov 21, 2024 |
Prolog information
The Trunk Group database item descriptions apply to historical items. Historical trunk group database items apply to the following tables:
  • Intrahour Trunk Group (htkgrp)
  • Daily Trunk Group (dtkgrp)
  • Weekly Trunk Group (wtkgrp)
  • Monthly Trunk Group (mtkgrp)
Unless indicated otherwise, items listed here are included in all four database tables.
Database item
Data type
Column type
Length
ABNCALLS
C
integer
4 bytes
ABNQUECALLS
C
integer
4 bytes
ABNRINGCALLS
C
integer
4 bytes
ABNVECCALLS
C
integer (htkgrp, dtkgrp, wtkgrp)
4 bytes
smallint (htkgrp)
2 bytes
ACD (index)
I
smallint
2 bytes
ACDCALLS
C
integer
4 bytes
ACDCALLS_R1
C
integer
4 bytes
ACDCALLS_R2
C
integer
4 bytes
ALLINUSETIME
C
integer
4 bytes
AUDIO
C
integer
4 bytes
BACKUPCALLS
C
integer
4 bytes
BH_ABNCALLS
B
integer (dtkgrp only)
4 bytes
BH_ACDCALLS
B
integer (dtkgrp only)
4 bytes
BH_ALLINUSETIME
B
integer (dtkgrp only)
4 bytes
BH_BUSYCALLS
B
integer (dtkgrp only)
4 bytes
BH_DISCCALLS
B
integer (dtkgrp only)
4 bytes
BH_INCALLS
B
integer (dtkgrp only)
4 bytes
BH_INTERVAL
B
integer (dtkgrp only)
4 bytes
BH_INTIME
B
integer (dtkgrp only)
4 bytes
BH_OABNCALLS
B
integer (dtkgrp only)
4 bytes
BH_OACDCALLS
B
integer (dtkgrp only)
4 bytes
BH_OOTHERCALLS
B
integer (dtkgrp only)
4 bytes
BH_OTHERCALLS
B
integer (dtkgrp only)
4 bytes
BH_OUTCALLS
B
integer (dtkgrp only)
4 bytes
BH_OUTTIME
B
integer (dtkgrp only)
4 bytes
BH_STARTTIME
B
integer (dtkgrp only)
4 bytes
BLOCKAGE
C
integer
4 bytes
BUSYCALLS
C
integer
4 bytes
COMPLETED
C
integer
4 bytes
CONNECTCALLS
C
integer
4 bytes
DISCCALLS
C
integer
4 bytes
FAILURES
C
integer
4 bytes
I_INOCC
C
integer (htkgrp)
4 bytes
int8 (dtkgrp, wtkgrp, mtkgrp)
8 bytes
I_OUTOCC
C
integer
4 bytes
ICRPULLCALLS
C
integer
4 bytes
ICRPULLQUECALLS
C
integer
4 bytes
ICRPULLRINGCALLS
C
integer
4 bytes
ICRPULLVECCALLS
C
integer
4 bytes
INCALLS
C
integer
4 bytes
INCOMPLETE
C
smallint
2 bytes
INTIME
C
integer (htkgrp, dtkgrp)
4 bytes
int8 (wtkgrp, mtkgrp)
8 bytes
INTRVL
A
smallint (htkgrp only)
2 bytes
MBUSYTIME
C
integer (htkgrp, dtkgrp)
4 bytes
int8 (wtkgrp, mtkgrp)
8 bytes
O_ABNCALLS
C
integer
4 bytes
O_ACDCALLS
C
integer
4 bytes
O_OTHERCALLS
C
integer
4 bytes
OTHERCALLS
C
integer
4 bytes
OUTCALLS
C
integer
4 bytes
OUTTIME
C
integer
4 bytes
PARTIAL_ARCHIVE
I
smallint (htkgrp only)
2 bytes
ROW_DATE (index)
I
date - Informix date
4 bytes
SETUPTIME
C
integer
4 bytes
SHORTCALLS
C
integer
4 bytes
SPLIT
A
smallint
2 bytes
STARTTIME
I
smallint (htkgrp only)
2 bytes
STARTTIME_UTC
I
integer (htkgrp only)
4 bytes
TENANT
I
integer
4 bytes
TIMEZONE
A
char(40) - ASCII text string (dtkgrp, wtkgrp, mtkgrp only)
40 bytes
TKGRP (index)
I
smallint
2 bytes
TRANSFERRED
C
integer
4 bytes
TRUNKS
A
smallint
2 bytes
VDN
A
char(16) - ASCII text string
16 bytes
VECTOR
A
smallint
2 bytes
TRUNKS
A
integer
4 bytes