Agent database items

Last Updated : Nov 20, 2024 |

The Agent database item descriptions apply only to historical items. Historical agent database items apply to the following tables:

  • Intrahour Agent (hagent)

  • Daily Agent (dagent)

  • Weekly Agent (wagent)

  • Monthly Agent (magent)

Unless indicated otherwise, all items listed here are included in all four database tables.

Database item

Data type

Column type

Length

ABNCALLS

C

smallint (dagent, hagent)

2 bytes

integer (magent, wagent)

4 bytes

ABNTIME

C

smallint (hagent)

4 bytes

integer (dagent, magent, wagent)

2 bytes

ACCEPTEDINTRS

C

smallint (hagent)

2 bytes

integer (dagent, wagent, magent)

4 bytes

ACD (index)

I

smallint

2 bytes

ACD_RELEASE

C

integer (dagent, wagent, magent table only)

4 bytes

ACDAUXOUTCALLS

C

smallint (dagent, hagent)

2 bytes

integer (wagent, magent)

4 bytes

ACDCALLS

C

smallint (dagent, hagent)

2 bytes

integer (wagent, magent)

4 bytes

ACDCALLS_R1

C

integer (dagent, wagent, magent)

4 bytes

smallint (hagent)

2 bytes

ACDCALLS_R2

C

integer (dagent, wagent, magent)

4 bytes

smallint (hagent)

2 bytes

ACDTIME

C

integer (dagent, wagent, magent)

4 bytes

smallint (hagent)

2 bytes

ACWINCALLS

C

smallint (dagent, hagent)

2 bytes

integer (wagent, magent)

4 bytes

ACWINTIME

C

integer (dagent, wagent, magent)

4 bytes

smallint (hagent)

2 bytes

ACWOUTADJCALLS

C

smallint (dagent, hagent)

2 bytes

integer (wagent, magent)

4 bytes

ACWOUTCALLS

C

smallint (dagent, hagent)

2 bytes

integer (wagent, magent)

4 bytes

ACWOUTOFFCALLS

C

smallint (dagent, hagent)

2 bytes

integer (wagent, magent)

4 bytes

ACWOUTOFFTIME

C

integer (dagent, magent, wagent)

4 bytes

smallint (hagent)

2 bytes

ACWOUTTIME

C

integer (dagent, magent, wagent)

4 bytes

smallint (hagent)

2 bytes

ACWTIME

C

integer (dagent, magent, wagent)

4 bytes

smallint (hagent)

2 bytes

ANSRINGTIME

C

integer (dagent, magent, wagent)

4 bytes

smallint (hagent)

2 bytes

ASSISTS

C

smallint (dagent, hagent)

2 bytes

integer (wagent, magent)

4 bytes

ATTRIB_ID

A

char(20) - alphanumeric string

20 bytes

AUXINCALLS

C

smallint (dagent, hagent)

2 bytes

integer (wagent, magent)

4 bytes

AUXINTIME

C

integer (dagent, magent, wagent)

4 bytes

smallint (hagent)

2 bytes

AUXOUTADJCALLS

C

smallint (dagent, hagent)

2 bytes

integer (wagent, magent)

4 bytes

AUXOUTCALLS

C

smallint (dagent, hagent)

2 bytes

integer (wagent, magent)

4 bytes

AUXOUTOFFCALLS

C

smallint (dagent, hagent)

2 bytes

integer (wagent, magent)

4 bytes

AUXOUTOFFTIME

C

integer (dagent, magent, wagent)

4 bytes

smallint (hagent)

2 bytes

AUXOUTTIME

C

integer (dagent, magent, wagent)

4 bytes

smallint (hagent)

2 bytes

CONFERENCE

C

smallint (dagent, hagent)

2 bytes

integer (wagent, magent)

4 bytes

DA_ABNCALLS

C

smallint (dagent, hagent)

2 bytes

integer (wagent, magent)

4 bytes

DA_ABNTIME

C

integer (dagent, magent, wagent)

4 bytes

smallint (hagent)

2 bytes

DA_ACDCALLS

C

smallint (dagent, hagent)

2 bytes

integer (wagent, magent)

4 bytes

DA_ACDTIME

C

integer (dagent, magent, wagent)

4 bytes

smallint (hagent)

2 bytes

DA_ACWINCALLS

C

smallint (dagent, hagent)

2 bytes

integer (wagent, magent)

4 bytes

DA_ACWINTIME

C

integer (dagent, magent, wagent)

4 bytes

smallint (hagent)

2 bytes

DA_ACWOADJCALLS

C

smallint (dagent, hagent)

2 bytes

integer (wagent, magent)

4 bytes

DA_ACWOCALLS

C

smallint (dagent, hagent)

2 bytes

integer (wagent, magent)

4 bytes

DA_ACWOOFFCALLS

C

smallint (dagent, hagent)

2 bytes

integer (wagent, magent)

4 bytes

DA_ACWOOFFTIME

C

integer (dagent, magent, wagent)

4 bytes

smallint (hagent)

2 bytes

DA_ACWOTIME

C

integer (dagent, magent, wagent)

4 bytes

smallint (hagent)

2 bytes

DA_ACWTIME

C

integer (dagent, magent, wagent)

4 bytes

smallint (hagent)

2 bytes

DA_ANSTIME

C

integer (dagent, magent, wagent)

4 bytes

smallint (hagent)

2 bytes

DA_ICRPULLCALLS

C

integer

4 bytes

DA_ICRPULLTIME

C

integer

4 bytes

DA_OTHERCALLS

C

smallint (dagent, hagent)

2 bytes

integer (wagent, magent)

4 bytes

DA_OTHERTIME

C

integer (dagent, magent, wagent)

4 bytes

smallint (hagent)

2 bytes

DA_RELEASE

C

integer

4 bytes

EVENT1-EVENT9

C

smallint (dagent, hagent)

2 bytes

integer (wagent, magent)

4 bytes

EXTENSION

A

char(16) - ASCII text string

16 bytes

HOLDABNCALLS

C

smallint (dagent, hagent)

2 bytes

integer (wagent, magent)

4 bytes

HOLDACDTIME

C

integer

4 bytes

HOLDCALLS

C

smallint (dagent, hagent)

2 bytes

integer (wagent, magent)

4 bytes

HOLDTIME

C

integer (dagent, magent, wagent)

4 bytes

smallint (hagent)

2 bytes

I_ACDAUXINTIME

C

integer (dagent, magent, wagent)

4 bytes

smallint (hagent)

2 bytes

I_ACDAUX_OUTTIME

C

integer (dagent, magent, wagent)

4 bytes

smallint (hagent)

2 bytes

I_ACDOTHERTIME

C

integer (dagent, magent, wagent)

4 bytes

smallint (hagent)

2 bytes

I_ACDTIME

C

integer (dagent, magent, wagent)

4 bytes

smallint (hagent)

2 bytes

I_ACWINTIME

C

integer (dagent, magent, wagent)

4 bytes

smallint (hagent)

2 bytes

I_ACWOUTTIME

C

integer (dagent, magent, wagent)

4 bytes

smallint (hagent)

2 bytes

I_ACWTIME

C

integer (dagent, magent, wagent)

4 bytes

smallint (hagent)

2 bytes

I_AUXINTIME

C

integer (dagent, magent, wagent)

4 bytes

smallint (hagent)

2 bytes

I_AUXOUTTIME

C

integer (dagent, magent, wagent)

4 bytes

smallint (hagent)

2 bytes

I_AUXSTBYTIME

C

integer (dagent, magent, wagent)

4 bytes

smallint (hagent)

2 bytes

I_AUXTIME

C

integer

4 bytes

I_AUXTIME0 - 99

C

integer

4 bytes

I_AUXTIME_R1

C

integer

4 bytes

I_AUXTIME_R2

C

integer

4 bytes

I_AVAILTIME

C

integer (dagent, magent, wagent)

4 bytes

smallint (hagent)

2 bytes

I_DA_ACDTIME

C

integer (dagent, magent, wagent)

4 bytes

smallint (hagent)

2 bytes

I_DA_ACWTIME

C

integer (dagent, magent, wagent)

4 bytes

smallint (hagent)

2 bytes

I_OTHERSTBYTIME

C

integer (dagent, magent, wagent)

4 bytes

smallint (hagent)

2 bytes

I_OTHERSTBYTIME_R1

C

integer (dagent, magent, wagent)

4 bytes

smallint (hagent)

2 bytes

I_OTHERSTBYTIME_R2

C

integer (dagent, magent, wagent)

4 bytes

smallint (hagent)

2 bytes

I_OTHERTIME

C

integer (dagent, magent, wagent)

4 bytes

smallint (hagent)

2 bytes

I_RINGTIME

C

integer (dagent, magent, wagent)

4 bytes

smallint (hagent)

2 bytes

I_STAFFTIME

C

integer (dagent, magent, wagent)

4 bytes

smallint (hagent)

2 bytes

ICRPULLCALLS

C

integer

4 bytes

ICRPULLTIME

C

integer

4 bytes

INCOMPLETE

C

smallint (hagent, dagent, wagent)

2 bytes

integer (magent)

4 bytes

INTRDELIVERIES

C

smallint (hagent)

2 bytes

integer (dagent, magent, wagent)

4 bytes

INTRNOTIFIES

C

smallint (hagent)

2 bytes

integer (dagent, magent, wagent)

4 bytes

INTRVL

A

smallint (hagent only)

2 bytes

LOC_ID

I

smallint

2 bytes

LOGID (index)

A

char(16) - ASCII text string

16 bytes

NOANSREDIR

C

smallint (dagent, hagent)

2 bytes

integer (wagent, magent)

4 bytes

O_ACDCALLS

C

smallint (dagent, hagent)

2 bytes

integer (wagent, magent)

4 bytes

O_ACDTIME

C

integer (dagent, magent, wagent)

4 bytes

smallint (hagent)

2 bytes

O_ACWTIME

C

integer (dagent, magent, wagent)

4 bytes

smallint (hagent)

2 bytes

PHANTOMABNS

C

smallint (dagent, hagent)

2 bytes

integer (wagent, magent)

4 bytes

REJECTEDINTRS

C

smallint (hagent)

2 bytes

integer (dagent, wagent, magent)

4 bytes

RINGCALLS

C

smallint (dagent, hagent)

2 bytes

integer (wagent, magent)

4 bytes

RINGTIME

C

integer (dagent, magent, wagent)

4 bytes

smallint (hagent)

2 bytes

ROIFREDIR

C

integer

4 bytes

ROOFREDIR

C

integer

4 bytes

ROW_DATE (index)

I

date - Informix date

4 bytes

RSV_LEVEL (index)

I

smallint

2 bytes

SPLIT (index)

I

smallint

2 bytes

STARTTIME

I

smallint (hagent only)

2 bytes

STARTTIME_UTC

I

integer (hagent only)

4 bytes

TENANT

I

integer

4 bytes

TI_AUXTIME

C

integer (dagent, magent, wagent)

4 bytes

smallint (hagent)

2 bytes

TI_AUXTIME0 - 9 or

TI_AUXTIME0 - 99

C

integer

4 bytes

TI_AVAILTIME

C

integer (dagent, magent, wagent)

4 bytes

smallint (hagent)

2 bytes

TI_OTHERTIME

C

integer (dagent, magent, wagent)

4 bytes

smallint (hagent)

2 bytes

TI_STAFFTIME

C

integer (dagent, magent, wagent)

4 bytes

smallint (hagent)

2 bytes

TIMEZONE

A

char(40) - ASCII text string (dagent, wagent, magent only)

40 bytes

TRANSFERRED

C

smallint (dagent, hagent)

4 bytes

integer (wagent, magent)

2 bytes

PARTIAL_ARCHIVE

I

smallint (hagent only)

2 bytes