Agent database items

Last Updated : Nov 20, 2024 |
Prolog information
Metadata
Keywords:
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