Itens da base de dados do agente

Última atualização : Apr 11, 2025 |
Prolog information
Metadata
Keywords:
As descrições de itens da base de dados do agente aplicam-se somente a itens históricos. Os itens do banco de dados históricos do agente aplicam-se às seguintes tabelas:
  • Agente intra-hora (hagent)
  • Agente diário (dagent)
  • Agente semanal (wagent)
  • Agente mensal (magent)
A menos que indicado de outra forma, todos os itens listados aqui estão incluídos em todas as quatro tabelas do banco de dados.
Item do banco de dados
Tipo de dados
Tipo de coluna
Duração
ABNCALLS
C
smallint (dagent, hagent)
2 bytes
inteiro (magent, wagent)
4 bytes
ABNTIME
C
smallint (hagent)
4 bytes
inteiro (dagent, magent, wagent)
2 bytes
ACCEPTEDINTRS
C
smallint (hagent)
2 bytes
inteiro (dagent, wagent, magent)
4 bytes
ACD (índice)
I
smallint
2 bytes
ACD_RELEASE
C
inteiro (dagent, wagent, magent somente tabela
4 bytes
ACDAUXOUTCALLS
C
smallint (dagent, hagent)
2 bytes
inteiro (wagent, magent)
4 bytes
ACDCALLS
C
smallint (dagent, hagent)
2 bytes
inteiro (wagent, magent)
4 bytes
ACDCALLS_R1
C
inteiro (dagent, wagent, magent)
4 bytes
smallint (hagent)
2 bytes
ACDCALLS_R2
C
inteiro (dagent, wagent, magent)
4 bytes
smallint (hagent)
2 bytes
ACDTIME
C
inteiro (dagent, wagent, magent)
4 bytes
smallint (hagent)
2 bytes
ACWINCALLS
C
smallint (dagent, hagent)
2 bytes
inteiro (wagent, magent)
4 bytes
ACWINTIME
C
inteiro (dagent, wagent, magent)
4 bytes
smallint (hagent)
2 bytes
ACWOUTADJCALLS
C
smallint (dagent, hagent)
2 bytes
inteiro (wagent, magent)
4 bytes
ACWOUTCALLS
C
smallint (dagent, hagent)
2 bytes
inteiro (wagent, magent)
4 bytes
ACWOUTOFFCALLS
C
smallint (dagent, hagent)
2 bytes
inteiro (wagent, magent)
4 bytes
ACWOUTOFFTIME
C
inteiro (dagent, magent, wagent)
4 bytes
smallint (hagent)
2 bytes
ACWOUTTIME
C
inteiro (dagent, magent, wagent)
4 bytes
smallint (hagent)
2 bytes
ACWTIME
C
inteiro (dagent, magent, wagent)
4 bytes
smallint (hagent)
2 bytes
ANSRINGTIME
C
inteiro (dagent, magent, wagent)
4 bytes
smallint (hagent)
2 bytes
ASSISTS
C
smallint (dagent, hagent)
2 bytes
inteiro (wagent, magent)
4 bytes
ATTRIB_ID
A
char(20) - sequência de caracteres alfanuméricos
20 bytes
AUXINCALLS
C
smallint (dagent, hagent)
2 bytes
inteiro (wagent, magent)
4 bytes
AUXINTIME
C
inteiro (dagent, magent, wagent)
4 bytes
smallint (hagent)
2 bytes
AUXOUTADJCALLS
C
smallint (dagent, hagent)
2 bytes
inteiro (wagent, magent)
4 bytes
AUXOUTCALLS
C
smallint (dagent, hagent)
2 bytes
inteiro (wagent, magent)
4 bytes
AUXOUTOFFCALLS
C
smallint (dagent, hagent)
2 bytes
inteiro (wagent, magent)
4 bytes
AUXOUTOFFTIME
C
inteiro (dagent, magent, wagent)
4 bytes
smallint (hagent)
2 bytes
AUXOUTTIME
C
inteiro (dagent, magent, wagent)
4 bytes
smallint (hagent)
2 bytes
CONFERENCE
C
smallint (dagent, hagent)
2 bytes
inteiro (wagent, magent)
4 bytes
DA_ABNCALLS
C
smallint (dagent, hagent)
2 bytes
inteiro (wagent, magent)
4 bytes
DA_ABNTIME
C
inteiro (dagent, magent, wagent)
4 bytes
smallint (hagent)
2 bytes
DA_ACDCALLS
C
smallint (dagent, hagent)
2 bytes
inteiro (wagent, magent)
4 bytes
DA_ACDTIME
C
inteiro (dagent, magent, wagent)
4 bytes
smallint (hagent)
2 bytes
DA_ACWINCALLS
C
smallint (dagent, hagent)
2 bytes
inteiro (wagent, magent)
4 bytes
DA_ACWINTIME
C
inteiro (dagent, magent, wagent)
4 bytes
smallint (hagent)
2 bytes
DA_ACWOADJCALLS
C
smallint (dagent, hagent)
2 bytes
inteiro (wagent, magent)
4 bytes
DA_ACWOCALLS
C
smallint (dagent, hagent)
2 bytes
inteiro (wagent, magent)
4 bytes
DA_ACWOOFFCALLS
C
smallint (dagent, hagent)
2 bytes
inteiro (wagent, magent)
4 bytes
DA_ACWOOFFTIME
C
inteiro (dagent, magent, wagent)
4 bytes
smallint (hagent)
2 bytes
DA_ACWOTIME
C
inteiro (dagent, magent, wagent)
4 bytes
smallint (hagent)
2 bytes
DA_ACWTIME
C
inteiro (dagent, magent, wagent)
4 bytes
smallint (hagent)
2 bytes
DA_ANSTIME
C
inteiro (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
inteiro (wagent, magent)
4 bytes
DA_OTHERTIME
C
inteiro (dagent, magent, wagent)
4 bytes
smallint (hagent)
2 bytes
DA_RELEASE
C
integer
4 bytes
EVENT1-EVENT9
C
smallint (dagent, hagent)
2 bytes
inteiro (wagent, magent)
4 bytes
EXTENSION
A
char(16) - sequência de texto ASCII
16 bytes
HOLDABNCALLS
C
smallint (dagent, hagent)
2 bytes
inteiro (wagent, magent)
4 bytes
HOLDACDTIME
C
integer
4 bytes
HOLDCALLS
C
smallint (dagent, hagent)
2 bytes
inteiro (wagent, magent)
4 bytes
HOLDTIME
C
inteiro (dagent, magent, wagent)
4 bytes
smallint (hagent)
2 bytes
I_ACDAUXINTIME
C
inteiro (dagent, magent, wagent)
4 bytes
smallint (hagent)
2 bytes
I_ACDAUX_OUTTIME
C
inteiro (dagent, magent, wagent)
4 bytes
smallint (hagent)
2 bytes
I_ACDOTHERTIME
C
inteiro (dagent, magent, wagent)
4 bytes
smallint (hagent)
2 bytes
I_ACDTIME
C
inteiro (dagent, magent, wagent)
4 bytes
smallint (hagent)
2 bytes
I_ACWINTIME
C
inteiro (dagent, magent, wagent)
4 bytes
smallint (hagent)
2 bytes
I_ACWOUTTIME
C
inteiro (dagent, magent, wagent)
4 bytes
smallint (hagent)
2 bytes
I_ACWTIME
C
inteiro (dagent, magent, wagent)
4 bytes
smallint (hagent)
2 bytes
I_AUXINTIME
C
inteiro (dagent, magent, wagent)
4 bytes
smallint (hagent)
2 bytes
I_AUXOUTTIME
C
inteiro (dagent, magent, wagent)
4 bytes
smallint (hagent)
2 bytes
I_AUXSTBYTIME
C
inteiro (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
inteiro (dagent, magent, wagent)
4 bytes
smallint (hagent)
2 bytes
I_DA_ACDTIME
C
inteiro (dagent, magent, wagent)
4 bytes
smallint (hagent)
2 bytes
I_DA_ACWTIME
C
inteiro (dagent, magent, wagent)
4 bytes
smallint (hagent)
2 bytes
I_OTHERSTBYTIME
C
inteiro (dagent, magent, wagent)
4 bytes
smallint (hagent)
2 bytes
I_OTHERSTBYTIME_R1
C
inteiro (dagent, magent, wagent)
4 bytes
smallint (hagent)
2 bytes
I_OTHERSTBYTIME_R2
C
inteiro (dagent, magent, wagent)
4 bytes
smallint (hagent)
2 bytes
I_OTHERTIME
C
inteiro (dagent, magent, wagent)
4 bytes
smallint (hagent)
2 bytes
I_RINGTIME
C
inteiro (dagent, magent, wagent)
4 bytes
smallint (hagent)
2 bytes
I_STAFFTIME
C
inteiro (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
inteiro (magent)
4 bytes
INTRDELIVERIES
C
smallint (hagent)
2 bytes
inteiro (dagent, magent, wagent)
4 bytes
INTRNOTIFIES
C
smallint (hagent)
2 bytes
inteiro (dagent, magent, wagent)
4 bytes
INTRVL
A
smallint (hagent apenas)
2 bytes
LOC_ID
I
smallint
2 bytes
LOGID (índice)
A
char(16) - sequência de texto ASCII
16 bytes
NOANSREDIR
C
smallint (dagent, hagent)
2 bytes
inteiro (wagent, magent)
4 bytes
O_ACDCALLS
C
smallint (dagent, hagent)
2 bytes
inteiro (wagent, magent)
4 bytes
O_ACDTIME
C
inteiro (dagent, magent, wagent)
4 bytes
smallint (hagent)
2 bytes
O_ACWTIME
C
inteiro (dagent, magent, wagent)
4 bytes
smallint (hagent)
2 bytes
PHANTOMABNS
C
smallint (dagent, hagent)
2 bytes
inteiro (wagent, magent)
4 bytes
REJECTEDINTRS
C
smallint (hagent)
2 bytes
inteiro (dagent, wagent, magent)
4 bytes
RINGCALLS
C
smallint (dagent, hagent)
2 bytes
inteiro (wagent, magent)
4 bytes
RINGTIME
C
inteiro (dagent, magent, wagent)
4 bytes
smallint (hagent)
2 bytes
ROIFREDIR
C
integer
4 bytes
ROOFREDIR
C
integer
4 bytes
ROW_DATE (índice)
I
data - data Informix
4 bytes
RSV_LEVEL (índice)
I
smallint
2 bytes
SPLIT (índice)
I
smallint
2 bytes
STARTTIME
I
smallint (hagent apenas)
2 bytes
STARTTIME_UTC
I
inteiro (hagent apenas)
4 bytes
TENANT
I
integer
4 bytes
TI_AUXTIME
C
inteiro (dagent, magent, wagent)
4 bytes
smallint (hagent)
2 bytes
TI_AUXTIME0 - 9 ou
TI_AUXTIME0 - 99
C
integer
4 bytes
TI_AVAILTIME
C
inteiro (dagent, magent, wagent)
4 bytes
smallint (hagent)
2 bytes
TI_OTHERTIME
C
inteiro (dagent, magent, wagent)
4 bytes
smallint (hagent)
2 bytes
TI_STAFFTIME
C
inteiro (dagent, magent, wagent)
4 bytes
smallint (hagent)
2 bytes
TIMEZONE
A
char(40) - sequência de texto ASCII (dagent, wagent, magent apenas)
40 bytes
TRANSFERRED
C
smallint (dagent, hagent)
4 bytes
inteiro (wagent, magent)
2 bytes
PARTIAL_ARCHIVE
I
smallint (hagent apenas)
2 bytes