Trunk database items

Last Updated : Nov 21, 2024 |

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