Elementi del database Agente

Ultimo aggiornamento : Apr 11, 2025 |
Prolog information
Metadata
Keywords:
Le descrizioni degli elementi del database Agente si riferiscono solo agli elementi cronologici. Gli elementi del database agente della cronologia si riferiscono alle tabelle seguenti:
  • Agente intraorario (hagent)
  • Agente giornaliero (dagent)
  • Agente settimanale (wagent)
  • Agente mensile (magent)
Salvo diversamente indicato, tutti gli elementi elencati qui sono inclusi in tutte e quattro le tabelle del database.
Elemento del database
Tipo dati
Tipo colonna
Lunghezza
ABNCALLS
C
smallint (dagent, hagent)
2 byte
numero intero (magent, wagent)
4 byte
ABNTIME
C
smallint (hagent)
4 byte
numero intero (dagent, magent, wagent)
2 byte
ACCEPTEDINTRS
C
smallint (hagent)
2 byte
numero intero (dagent, wagent, magent)
4 byte
ACD (indice)
I
smallint
2 byte
ACD_RELEASE
C
numero intero (dagent, wagent, magent solo tabella)
4 byte
ACDAUXOUTCALLS
C
smallint (dagent, hagent)
2 byte
numero intero (wagent, magent)
4 byte
ACDCALLS
C
smallint (dagent, hagent)
2 byte
numero intero (wagent, magent)
4 byte
ACDCALLS_R1
C
numero intero (dagent, wagent, magent)
4 byte
smallint (hagent)
2 byte
ACDCALLS_R2
C
numero intero (dagent, wagent, magent)
4 byte
smallint (hagent)
2 byte
ACDTIME
C
numero intero (dagent, wagent, magent)
4 byte
smallint (hagent)
2 byte
ACWINCALLS
C
smallint (dagent, hagent)
2 byte
numero intero (wagent, magent)
4 byte
ACWINTIME
C
numero intero (dagent, wagent, magent)
4 byte
smallint (hagent)
2 byte
ACWOUTADJCALLS
C
smallint (dagent, hagent)
2 byte
numero intero (wagent, magent)
4 byte
ACWOUTCALLS
C
smallint (dagent, hagent)
2 byte
numero intero (wagent, magent)
4 byte
ACWOUTOFFCALLS
C
smallint (dagent, hagent)
2 byte
numero intero (wagent, magent)
4 byte
ACWOUTOFFTIME
C
numero intero (dagent, magent, wagent)
4 byte
smallint (hagent)
2 byte
ACWOUTTIME
C
numero intero (dagent, magent, wagent)
4 byte
smallint (hagent)
2 byte
ACWTIME
C
numero intero (dagent, magent, wagent)
4 byte
smallint (hagent)
2 byte
ANSRINGTIME
C
numero intero (dagent, magent, wagent)
4 byte
smallint (hagent)
2 byte
ASSISTS
C
smallint (dagent, hagent)
2 byte
numero intero (wagent, magent)
4 byte
ATTRIB_ID
A
char(20) - stringa alfanumerica
20 byte
AUXINCALLS
C
smallint (dagent, hagent)
2 byte
numero intero (wagent, magent)
4 byte
AUXINTIME
C
numero intero (dagent, magent, wagent)
4 byte
smallint (hagent)
2 byte
AUXOUTADJCALLS
C
smallint (dagent, hagent)
2 byte
numero intero (wagent, magent)
4 byte
AUXOUTCALLS
C
smallint (dagent, hagent)
2 byte
numero intero (wagent, magent)
4 byte
AUXOUTOFFCALLS
C
smallint (dagent, hagent)
2 byte
numero intero (wagent, magent)
4 byte
AUXOUTOFFTIME
C
numero intero (dagent, magent, wagent)
4 byte
smallint (hagent)
2 byte
AUXOUTTIME
C
numero intero (dagent, magent, wagent)
4 byte
smallint (hagent)
2 byte
CONFERENCE
C
smallint (dagent, hagent)
2 byte
numero intero (wagent, magent)
4 byte
DA_ABNCALLS
C
smallint (dagent, hagent)
2 byte
numero intero (wagent, magent)
4 byte
DA_ABNTIME
C
numero intero (dagent, magent, wagent)
4 byte
smallint (hagent)
2 byte
DA_ACDCALLS
C
smallint (dagent, hagent)
2 byte
numero intero (wagent, magent)
4 byte
DA_ACDTIME
C
numero intero (dagent, magent, wagent)
4 byte
smallint (hagent)
2 byte
DA_ACWINCALLS
C
smallint (dagent, hagent)
2 byte
numero intero (wagent, magent)
4 byte
DA_ACWINTIME
C
numero intero (dagent, magent, wagent)
4 byte
smallint (hagent)
2 byte
DA_ACWOADJCALLS
C
smallint (dagent, hagent)
2 byte
numero intero (wagent, magent)
4 byte
DA_ACWOCALLS
C
smallint (dagent, hagent)
2 byte
numero intero (wagent, magent)
4 byte
DA_ACWOOFFCALLS
C
smallint (dagent, hagent)
2 byte
numero intero (wagent, magent)
4 byte
DA_ACWOOFFTIME
C
numero intero (dagent, magent, wagent)
4 byte
smallint (hagent)
2 byte
DA_ACWOTIME
C
numero intero (dagent, magent, wagent)
4 byte
smallint (hagent)
2 byte
DA_ACWTIME
C
numero intero (dagent, magent, wagent)
4 byte
smallint (hagent)
2 byte
DA_ANSTIME
C
numero intero (dagent, magent, wagent)
4 byte
smallint (hagent)
2 byte
DA_ICRPULLCALLS
C
numero intero
4 byte
DA_ICRPULLTIME
C
numero intero
4 byte
DA_OTHERCALLS
C
smallint (dagent, hagent)
2 byte
numero intero (wagent, magent)
4 byte
DA_OTHERTIME
C
numero intero (dagent, magent, wagent)
4 byte
smallint (hagent)
2 byte
DA_RELEASE
C
numero intero
4 byte
EVENT1-EVENT9
C
smallint (dagent, hagent)
2 byte
numero intero (wagent, magent)
4 byte
EXTENSION
A
char(16) - stringa di testo ASCII
16 byte
HOLDABNCALLS
C
smallint (dagent, hagent)
2 byte
numero intero (wagent, magent)
4 byte
HOLDACDTIME
C
numero intero
4 byte
HOLDCALLS
C
smallint (dagent, hagent)
2 byte
numero intero (wagent, magent)
4 byte
HOLDTIME
C
numero intero (dagent, magent, wagent)
4 byte
smallint (hagent)
2 byte
I_ACDAUXINTIME
C
numero intero (dagent, magent, wagent)
4 byte
smallint (hagent)
2 byte
I_ACDAUX_OUTTIME
C
numero intero (dagent, magent, wagent)
4 byte
smallint (hagent)
2 byte
I_ACDOTHERTIME
C
numero intero (dagent, magent, wagent)
4 byte
smallint (hagent)
2 byte
I_ACDTIME
C
numero intero (dagent, magent, wagent)
4 byte
smallint (hagent)
2 byte
I_ACWINTIME
C
numero intero (dagent, magent, wagent)
4 byte
smallint (hagent)
2 byte
I_ACWOUTTIME
C
numero intero (dagent, magent, wagent)
4 byte
smallint (hagent)
2 byte
I_ACWTIME
C
numero intero (dagent, magent, wagent)
4 byte
smallint (hagent)
2 byte
I_AUXINTIME
C
numero intero (dagent, magent, wagent)
4 byte
smallint (hagent)
2 byte
I_AUXOUTTIME
C
numero intero (dagent, magent, wagent)
4 byte
smallint (hagent)
2 byte
I_AUXSTBYTIME
C
numero intero (dagent, magent, wagent)
4 byte
smallint (hagent)
2 byte
I_AUXTIME
C
numero intero
4 byte
I_AUXTIME0 - 99
C
numero intero
4 byte
I_AUXTIME_R1
C
numero intero
4 byte
I_AUXTIME_R2
C
numero intero
4 byte
I_AVAILTIME
C
numero intero (dagent, magent, wagent)
4 byte
smallint (hagent)
2 byte
I_DA_ACDTIME
C
numero intero (dagent, magent, wagent)
4 byte
smallint (hagent)
2 byte
I_DA_ACWTIME
C
numero intero (dagent, magent, wagent)
4 byte
smallint (hagent)
2 byte
I_OTHERSTBYTIME
C
numero intero (dagent, magent, wagent)
4 byte
smallint (hagent)
2 byte
I_OTHERSTBYTIME_R1
C
numero intero (dagent, magent, wagent)
4 byte
smallint (hagent)
2 byte
I_OTHERSTBYTIME_R2
C
numero intero (dagent, magent, wagent)
4 byte
smallint (hagent)
2 byte
I_OTHERTIME
C
numero intero (dagent, magent, wagent)
4 byte
smallint (hagent)
2 byte
I_RINGTIME
C
numero intero (dagent, magent, wagent)
4 byte
smallint (hagent)
2 byte
I_STAFFTIME
C
numero intero (dagent, magent, wagent)
4 byte
smallint (hagent)
2 byte
ICRPULLCALLS
C
numero intero
4 byte
ICRPULLTIME
C
numero intero
4 byte
INCOMPLETE
C
smallint (hagent, dagent, wagent)
2 byte
numero intero (magent)
4 byte
INTRDELIVERIES
C
smallint (hagent)
2 byte
numero intero (dagent, magent, wagent)
4 byte
INTRNOTIFIES
C
smallint (hagent)
2 byte
numero intero (dagent, magent, wagent)
4 byte
INTRVL
A
smallint (hagent solo)
2 byte
LOC_ID
I
smallint
2 byte
LOGID (indice)
A
char(16) - stringa di testo ASCII
16 byte
NOANSREDIR
C
smallint (dagent, hagent)
2 byte
numero intero (wagent, magent)
4 byte
O_ACDCALLS
C
smallint (dagent, hagent)
2 byte
numero intero (wagent, magent)
4 byte
O_ACDTIME
C
numero intero (dagent, magent, wagent)
4 byte
smallint (hagent)
2 byte
O_ACWTIME
C
numero intero (dagent, magent, wagent)
4 byte
smallint (hagent)
2 byte
PHANTOMABNS
C
smallint (dagent, hagent)
2 byte
numero intero (wagent, magent)
4 byte
REJECTEDINTRS
C
smallint (hagent)
2 byte
numero intero (dagent, wagent, magent)
4 byte
RINGCALLS
C
smallint (dagent, hagent)
2 byte
numero intero (wagent, magent)
4 byte
RINGTIME
C
numero intero (dagent, magent, wagent)
4 byte
smallint (hagent)
2 byte
ROIFREDIR
C
numero intero
4 byte
ROOFREDIR
C
numero intero
4 byte
ROW_DATE (indice)
I
data - data Informix
4 byte
RSV_LEVEL (indice)
I
smallint
2 byte
SPLIT (indice)
I
smallint
2 byte
STARTTIME
I
smallint (hagent solo)
2 byte
STARTTIME_UTC
I
numero intero (hagent solo)
4 byte
TENANT
I
numero intero
4 byte
TI_AUXTIME
C
numero intero (dagent, magent, wagent)
4 byte
smallint (hagent)
2 byte
TI_AUXTIME0 - 9 o
TI_AUXTIME0 - 99
C
numero intero
4 byte
TI_AVAILTIME
C
numero intero (dagent, magent, wagent)
4 byte
smallint (hagent)
2 byte
TI_OTHERTIME
C
numero intero (dagent, magent, wagent)
4 byte
smallint (hagent)
2 byte
TI_STAFFTIME
C
numero intero (dagent, magent, wagent)
4 byte
smallint (hagent)
2 byte
TIMEZONE
A
char(40) - stringa di testo ASCII (dagent, wagent, magent solo)
40 byte
TRANSFERRED
C
smallint (dagent, hagent)
4 byte
numero intero (wagent, magent)
2 byte
PARTIAL_ARCHIVE
I
smallint (hagent solo)
2 byte