Itens da base de dados do agente

Última atualização : May 11, 2026 |

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