Itens da base de dados de grupo/especialidade

Última atualização : Apr 11, 2025 |
Prolog information
Metadata
Keywords:
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