Trunk Group database items

Last Updated : Nov 21, 2024 |

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