Itens da base de dados de grupo/especialidade

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

As descrições de itens da base de dados de Grupo/Especialidade aplicam-se a itens históricos. Os itens da base de dados históricos de grupo/especialidade aplicam-se as seguintes tabelas:

  • grupo/especialidade intra-hora (hsplit)

  • grupo/especialidade diário (dsplit)

  • grupo/especialidade semanal (wsplit)

  • grupo/especialidade mensal (msplit)

A menos que seja especificado de outra forma, todos os itens do banco de dados listados aqui estão incluídos em todas as quatro tabelas.

Item do banco de dados

Tipo de dados

Tipo de coluna

Duração

ABNCALLS

C

integer

4 bytes

ABNCALLS1-ABNCALLS10

C

integer

4 bytes

ABNCALLSACC1-ABNCALLSACC10

C

inteiro (dsplit, wsplit, msplit)

4 bytes

smallint (hsplit)

2 bytes

ABNRINGCALLS

C

integer

4 bytes

ABNTIME

C

integer

4 bytes

ACCEPTABLE

C

integer

4 bytes

ACCEPTABLEACC

C

integer

4 bytes

ACD (índice)

C

inteiro (dsplit, wsplit, msplit)

4 bytes

smallint (hsplit)

2 bytes

ACDAUXOUTCALLS

A

integer

4 bytes

ACDCALLS

C

integer

4 bytes

ACDCALLS1-ACDCALLS10

C

integer

4 bytes

ACDCALLSACC1-ACDCALLSACC10

C

inteiro (dsplit, wsplit, msplit)

4 bytes

smallint (hsplit)

2 bytes

ACDCALLS_R1

C

integer

4 bytes

ACDCALLS_R2

C

integer

4 bytes

ACDTIME

C

inteiro (hsplit, dsplit)

4 bytes

int8 (wsplit, msplit)

8 bytes

ACWINCALLS

C

integer

4 bytes

ACWINTIME

C

inteiro (dsplit, wsplit, msplit)

4 bytes

smallint (hsplit)

2 bytes

ACWOUTADJCALLS

C

integer

4 bytes

ACWOUTCALLS

C

integer

4 bytes

ACWOUTOFFCALLS

C

inteiro (dsplit, wsplit, msplit)

4 bytes

smallint (hsplit)

2 bytes

ACWOUTOFFTIME

C

inteiro (dsplit, wsplit, msplit)

4 bytes

smallint (hsplit)

2 bytes

ACWOUTTIME

C

integer

4 bytes

ACWTIME

C

inteiro (hsplit, dsplit)

4 bytes

int8 (wsplit, msplit)

8 bytes

AGSURPDELIVERIES

C

integer

4 bytes

AGSURPNPREFCALLS

C

integer

4 bytes

AGSURPPREFCALLS

C

integer

4 bytes

ANSTIME

C

integer

4 bytes

ASSISTS

C

integer

4 bytes

AUXINCALLS

C

integer

4 bytes

AUXINTIME

C

integer

4 bytes

AUXOUTADJCALLS

C

integer

4 bytes

AUXOUTCALLS

C

integer

4 bytes

AUXOUTOFFCALLS

C

integer

4 bytes

AUXOUTOFFTIME

C

integer

4 bytes

AUXOUTTIME

C

integer

4 bytes

BACKUPCALLS

C

integer

4 bytes

BUSYCALLS

C

integer

4 bytes

BUSYTIME

C

integer

4 bytes

CALLSOFFERED

C

integer

4 bytes

CALLSURPDELIVERIES

C

integer

4 bytes

CONFERENCE

C

integer

4 bytes

DA_ACWINCALLS

C

integer

4 bytes

DA_ACWINTIME

C

integer

4 bytes

DA_ACWOCALLS

C

integer

4 bytes

DA_ACWOTIME

C

integer

4 bytes

DEQUECALLS

C

integer

4 bytes

DEQUETIME

C

integer

4 bytes

DISCCALLS

C

integer

4 bytes

DISCTIME

C

integer

4 bytes

EVENT1-EVENT9

C

integer

4 bytes

HIGHCALLS

C

integer

4 bytes

HOLDABNCALLS

C

integer

4 bytes

HOLDCALLS

C

integer

4 bytes

HOLDTIME

C

inteiro (hsplit, dsplit)

4 bytes

int8 (wsplit, msplit)

8 bytes

I_ACDAUXINTIME

C

integer

4 bytes

I_ACDAUX_OUTTIME

C

integer

4 bytes

I_ACDOTHERTIME

C

integer

4 bytes

I_ACDTIME

C

inteiro (hsplit, dsplit)

4 bytes

int8 (wsplit, msplit)

8 bytes

I_ACDTIME_R1

C

integer

4 bytes

I_ACDTIME_R2

C

integer

4 bytes

I_ACWINTIME

C

integer

4 bytes

I_ACWOUTTIME

C

integer

4 bytes

I_ACWTIME

C

inteiro (hsplit, dsplit)

4 bytes

int8 (wsplit, msplit)

8 bytes

I_ACWTIME_R1

C

integer

4 bytes

I_ACWTIME_R23

C

integer

4 bytes

I_ARRIVED

C

integer

4 bytes

I_AUXINTIME

C

integer

4 bytes

I_AUXOUTTIME

C

integer

4 bytes

I_AUXTIME

C

inteiro (hsplit, dsplit)

4 bytes

int8 (wsplit, msplit)

8 bytes

I_AUXTIME0

C

integer

4 bytes

I_AUXTIME1-9

C

integer

4 bytes

I_AUXSTBYTIME_R1

C

integer

4 bytes

I_AUXSTBYTIME_R2

C

integer

4 bytes

I_AUXTIME_R1

C

integer

4 bytes

I_AUXTIME_R2

C

integer

4 bytes

I_AVAILTIME

C

inteiro (hsplit, dsplit)

4 bytes

int8 (wsplit, msplit)

8 bytes

I_DA_ACDTIME

C

integer

4 bytes

I_DA_ACWTIME

C

integer

4 bytes

I_NORMTIME

C

integer

4 bytes

I_OL1TIME

C

integer

4 bytes

I_OL2TIME

C

integer

4 bytes

I_OTHERSTBYTIME_R1

C

integer

4 bytes

I_OTHERSTBYTIME_R2

C

integer

4 bytes

I_OTHERTIME

C

inteiro (hsplit, dsplit)

4 bytes

int8 (wsplit, msplit)

8 bytes

I_OTHERTIME_R1

C

integer

4 bytes

I_OTHERTIME_R2

C

integer

4 bytes

I_RINGTIME

C

integer

4 bytes

I_RINGTIME_R1

C

integer

4 bytes

I_RINGTIME_R2

C

integer

4 bytes

I_STAFFTIME

C

inteiro (hsplit, dsplit)

4 bytes

int8 (wsplit, msplit)

8 bytes

I_TAUXTIME

C

integer

4 bytes

I_TAVAILTIME

C

inteiro (hsplit, dsplit)

4 bytes

int8 (wsplit, msplit)

8 bytes

I_TOTHERTIME

C

inteiro (hsplit, dsplit)

4 bytes

int8 (wsplit, msplit)

8 bytes

ICRPULLCALLS

C

integer

4 bytes

ICRPULLRINGCALLS

C

integer

4 bytes

ICRPULLTIME

C

integer

4 bytes

INCOMPLETE

C

smallint

2 bytes

INFLOWCALLS

C

integer

4 bytes

INTERFLOWCALLS

C

integer

4 bytes

INTRDELIVERIES

C

integer

4 bytes

INTRVL

A

smallint

2 bytes

LOWCALLS

C

integer

4 bytes

MAXINQUEUE

M

inteiro (dsplit, wsplit, msplit)

4 bytes

smallint (hsplit)

2 bytes

MAXOCWTIME

M

integer

4 bytes

MAXSTAFFED

M

inteiro (dsplit, wsplit, msplit)

4 bytes

smallint (hsplit)

2 bytes

MAXTOP

M

integer

4 bytes

MAX_TOT_PERCENTS

C

integer

4 bytes

MEDCALLS

C

integer

4 bytes

NOANSREDIR

C

integer

4 bytes

O_ABNCALLS

C

integer

4 bytes

O_ACDCALLS

C

integer

4 bytes

O_ACDTIME

C

integer

4 bytes

O_ACWTIME

C

integer

4 bytes

O_OTHERCALLS

C

integer

4 bytes

OTHERCALLS

C

integer

4 bytes

OTHERTIME

C

integer

4 bytes

OUTFLOWCALLS

C

integer

4 bytes

OUTFLOWTIME

C

integer

4 bytes

PARTIAL_ARCHIVE

I

smallint

2 bytes

PERIOD1-PERIOD9

A

smallint

2 bytes

PERIODCHG

A

inteiro (dsplit, wsplit, msplit)

4 bytes

smallint (hsplit)

2 bytes

PHANTOMABNS

C

integer

4 bytes

REDIRECTCALLS

C

integer

4 bytes

RINGCALLS

C

integer

4 bytes

RINGTIME

C

integer

4 bytes

ROIFREDIR

C

integer

4 bytes

ROOFREDIR

C

integer

4 bytes

ROW_DATE (índice)

I

data - data Informix

4 bytes

RSV_LEVEL

smallint

2 bytes

SERVICELEVEL

A

inteiro (dsplit, wsplit, msplit)

4 bytes

smallint (hsplit)

2 bytes

SLVLABNS

C

integer

4 bytes

SLVLABNSACC

C

integer

4 bytes

SLVLOUTFLOWS

C

integer

4 bytes

SPLIT (índice)

I

smallint (dsplit, wsplit, msplit)

2 bytes

STARTTIME

I

smallint (hsplit apenas)

2 bytes

STARTTIME_UTC

I

inteiro (hsplit apenas)

4 bytes

SVCLEVELCHG

A

inteiro (dsplit, wsplit, msplit)

4 bytes

smallint (hsplit)

2 bytes

TENANT

I

integer

4 bytes

TARGETACDCALLS

integer

4 bytes

TARGETABNS

integer

4 bytes

TARGETOUTFLOWS

integer

4 bytes

TIMEZONE

A

char(40) - texto ASCII (dsplit, wsplit, msplit apenas)

40 bytes

TOPCALLS

C

integer

4 bytes

TRANSFERRED

C

integer

4 bytes