Attributs de la base de données Agent

Dernière mise à jour : Apr 11, 2025 |
Informations sur le prologue
Métadonnées
Mots-clés :
Les descriptions des attributs de la base de données Agent s'appliquent uniquement aux attributs historiques. Les attributs historiques de la base de données de l'agent s'appliquent aux tables suivantes :
  • Horaire de l'agent (hagent)
  • Quotidienne de l'agent (dagent)
  • Hebdomadaire de l'agent (wagent)
  • Mensuelle de l'agent (magent)
Sauf indication contraire, tous les attributs figurant ici sont inclus dans les quatre tables de base de données.
Attribut de la base de données
Type de données
Type de colonne
Longueur
ABNCALLS
C
smallint (dagent, hagent)
2 octets
integer (magent, wagent)
4 octets
ABNTIME
C
smallint (hagent)
4 octets
integer (dagent, magent, wagent)
2 octets
ACCEPTEDINTRS
C
smallint (hagent)
2 octets
integer (dagent, wagent, magent)
4 octets
ACD (index)
I
smallint
2 octets
ACD_RELEASE
C
integer (dagent, wagent, magent table uniquement)
4 octets
ACDAUXOUTCALLS
C
smallint (dagent, hagent)
2 octets
integer (wagent, magent)
4 octets
ACDCALLS
C
smallint (dagent, hagent)
2 octets
integer (wagent, magent)
4 octets
ACDCALLS_R1
C
integer (dagent, wagent, magent)
4 octets
smallint (hagent)
2 octets
ACDCALLS_R2
C
integer (dagent, wagent, magent)
4 octets
smallint (hagent)
2 octets
ACDTIME
C
integer (dagent, wagent, magent)
4 octets
smallint (hagent)
2 octets
ACWINCALLS
C
smallint (dagent, hagent)
2 octets
integer (wagent, magent)
4 octets
ACWINTIME
C
integer (dagent, wagent, magent)
4 octets
smallint (hagent)
2 octets
ACWOUTADJCALLS
C
smallint (dagent, hagent)
2 octets
integer (wagent, magent)
4 octets
ACWOUTCALLS
C
smallint (dagent, hagent)
2 octets
integer (wagent, magent)
4 octets
ACWOUTOFFCALLS
C
smallint (dagent, hagent)
2 octets
integer (wagent, magent)
4 octets
ACWOUTOFFTIME
C
integer (dagent, magent, wagent)
4 octets
smallint (hagent)
2 octets
ACWOUTTIME
C
integer (dagent, magent, wagent)
4 octets
smallint (hagent)
2 octets
ACWTIME
C
integer (dagent, magent, wagent)
4 octets
smallint (hagent)
2 octets
ANSRINGTIME
C
integer (dagent, magent, wagent)
4 octets
smallint (hagent)
2 octets
ASSISTS
C
smallint (dagent, hagent)
2 octets
integer (wagent, magent)
4 octets
ATTRIB_ID
A
char(20) - chaîne alphanumérique
20 octets
AUXINCALLS
C
smallint (dagent, hagent)
2 octets
integer (wagent, magent)
4 octets
AUXINTIME
C
integer (dagent, magent, wagent)
4 octets
smallint (hagent)
2 octets
AUXOUTADJCALLS
C
smallint (dagent, hagent)
2 octets
integer (wagent, magent)
4 octets
AUXOUTCALLS
C
smallint (dagent, hagent)
2 octets
integer (wagent, magent)
4 octets
AUXOUTOFFCALLS
C
smallint (dagent, hagent)
2 octets
integer (wagent, magent)
4 octets
AUXOUTOFFTIME
C
integer (dagent, magent, wagent)
4 octets
smallint (hagent)
2 octets
AUXOUTTIME
C
integer (dagent, magent, wagent)
4 octets
smallint (hagent)
2 octets
CONFERENCE
C
smallint (dagent, hagent)
2 octets
integer (wagent, magent)
4 octets
DA_ABNCALLS
C
smallint (dagent, hagent)
2 octets
integer (wagent, magent)
4 octets
DA_ABNTIME
C
integer (dagent, magent, wagent)
4 octets
smallint (hagent)
2 octets
DA_ACDCALLS
C
smallint (dagent, hagent)
2 octets
integer (wagent, magent)
4 octets
DA_ACDTIME
C
integer (dagent, magent, wagent)
4 octets
smallint (hagent)
2 octets
DA_ACWINCALLS
C
smallint (dagent, hagent)
2 octets
integer (wagent, magent)
4 octets
DA_ACWINTIME
C
integer (dagent, magent, wagent)
4 octets
smallint (hagent)
2 octets
DA_ACWOADJCALLS
C
smallint (dagent, hagent)
2 octets
integer (wagent, magent)
4 octets
DA_ACWOCALLS
C
smallint (dagent, hagent)
2 octets
integer (wagent, magent)
4 octets
DA_ACWOOFFCALLS
C
smallint (dagent, hagent)
2 octets
integer (wagent, magent)
4 octets
DA_ACWOOFFTIME
C
integer (dagent, magent, wagent)
4 octets
smallint (hagent)
2 octets
DA_ACWOTIME
C
integer (dagent, magent, wagent)
4 octets
smallint (hagent)
2 octets
DA_ACWTIME
C
integer (dagent, magent, wagent)
4 octets
smallint (hagent)
2 octets
DA_ANSTIME
C
integer (dagent, magent, wagent)
4 octets
smallint (hagent)
2 octets
DA_ICRPULLCALLS
C
integer
4 octets
DA_ICRPULLTIME
C
integer
4 octets
DA_OTHERCALLS
C
smallint (dagent, hagent)
2 octets
integer (wagent, magent)
4 octets
DA_OTHERTIME
C
integer (dagent, magent, wagent)
4 octets
smallint (hagent)
2 octets
DA_RELEASE
C
integer
4 octets
EVENT1-EVENT9
C
smallint (dagent, hagent)
2 octets
integer (wagent, magent)
4 octets
EXTENSION
A
char(16) - chaîne de caractères ASCII
16 octets
HOLDABNCALLS
C
smallint (dagent, hagent)
2 octets
integer (wagent, magent)
4 octets
HOLDACDTIME
C
integer
4 octets
HOLDCALLS
C
smallint (dagent, hagent)
2 octets
integer (wagent, magent)
4 octets
HOLDTIME
C
integer (dagent, magent, wagent)
4 octets
smallint (hagent)
2 octets
I_ACDAUXINTIME
C
integer (dagent, magent, wagent)
4 octets
smallint (hagent)
2 octets
I_ACDAUX_OUTTIME
C
integer (dagent, magent, wagent)
4 octets
smallint (hagent)
2 octets
I_ACDOTHERTIME
C
integer (dagent, magent, wagent)
4 octets
smallint (hagent)
2 octets
I_ACDTIME
C
integer (dagent, magent, wagent)
4 octets
smallint (hagent)
2 octets
I_ACWINTIME
C
integer (dagent, magent, wagent)
4 octets
smallint (hagent)
2 octets
I_ACWOUTTIME
C
integer (dagent, magent, wagent)
4 octets
smallint (hagent)
2 octets
I_ACWTIME
C
integer (dagent, magent, wagent)
4 octets
smallint (hagent)
2 octets
I_AUXINTIME
C
integer (dagent, magent, wagent)
4 octets
smallint (hagent)
2 octets
I_AUXOUTTIME
C
integer (dagent, magent, wagent)
4 octets
smallint (hagent)
2 octets
I_AUXSTBYTIME
C
integer (dagent, magent, wagent)
4 octets
smallint (hagent)
2 octets
I_AUXTIME
C
integer
4 octets
I_AUXTIME0 - 99
C
integer
4 octets
I_AUXTIME_R1
C
integer
4 octets
I_AUXTIME_R2
C
integer
4 octets
I_AVAILTIME
C
integer (dagent, magent, wagent)
4 octets
smallint (hagent)
2 octets
I_DA_ACDTIME
C
integer (dagent, magent, wagent)
4 octets
smallint (hagent)
2 octets
I_DA_ACWTIME
C
integer (dagent, magent, wagent)
4 octets
smallint (hagent)
2 octets
I_OTHERSTBYTIME
C
integer (dagent, magent, wagent)
4 octets
smallint (hagent)
2 octets
I_OTHERSTBYTIME_R1
C
integer (dagent, magent, wagent)
4 octets
smallint (hagent)
2 octets
I_OTHERSTBYTIME_R2
C
integer (dagent, magent, wagent)
4 octets
smallint (hagent)
2 octets
I_OTHERTIME
C
integer (dagent, magent, wagent)
4 octets
smallint (hagent)
2 octets
I_RINGTIME
C
integer (dagent, magent, wagent)
4 octets
smallint (hagent)
2 octets
I_STAFFTIME
C
integer (dagent, magent, wagent)
4 octets
smallint (hagent)
2 octets
ICRPULLCALLS
C
integer
4 octets
ICRPULLTIME
C
integer
4 octets
INCOMPLETE
C
smallint (hagent, dagent, wagent)
2 octets
integer (magent)
4 octets
INTRDELIVERIES
C
smallint (hagent)
2 octets
integer (dagent, magent, wagent)
4 octets
INTRNOTIFIES
C
smallint (hagent)
2 octets
integer (dagent, magent, wagent)
4 octets
INTRVL
A
smallint (hagent uniquement)
2 octets
LOC_ID
I
smallint
2 octets
LOGID (index)
A
char(16) - chaîne de caractères ASCII
16 octets
NOANSREDIR
C
smallint (dagent, hagent)
2 octets
integer (wagent, magent)
4 octets
O_ACDCALLS
C
smallint (dagent, hagent)
2 octets
integer (wagent, magent)
4 octets
O_ACDTIME
C
integer (dagent, magent, wagent)
4 octets
smallint (hagent)
2 octets
O_ACWTIME
C
integer (dagent, magent, wagent)
4 octets
smallint (hagent)
2 octets
PHANTOMABNS
C
smallint (dagent, hagent)
2 octets
integer (wagent, magent)
4 octets
REJECTEDINTRS
C
smallint (hagent)
2 octets
integer (dagent, wagent, magent)
4 octets
RINGCALLS
C
smallint (dagent, hagent)
2 octets
integer (wagent, magent)
4 octets
RINGTIME
C
integer (dagent, magent, wagent)
4 octets
smallint (hagent)
2 octets
ROIFREDIR
C
integer
4 octets
ROOFREDIR
C
integer
4 octets
ROW_DATE (index)
I
date - date Informix
4 octets
RSV_LEVEL (index)
I
smallint
2 octets
SPLIT (index)
I
smallint
2 octets
STARTTIME
I
smallint (hagent uniquement)
2 octets
STARTTIME_UTC
I
integer (hagent uniquement)
4 octets
TENANT
I
integer
4 octets
TI_AUXTIME
C
integer (dagent, magent, wagent)
4 octets
smallint (hagent)
2 octets
TI_AUXTIME0 - 9 ou
TI_AUXTIME0 - 99
C
integer
4 octets
TI_AVAILTIME
C
integer (dagent, magent, wagent)
4 octets
smallint (hagent)
2 octets
TI_OTHERTIME
C
integer (dagent, magent, wagent)
4 octets
smallint (hagent)
2 octets
TI_STAFFTIME
C
integer (dagent, magent, wagent)
4 octets
smallint (hagent)
2 octets
TIMEZONE
A
char(40) - chaîne de caractères ASCII (dagent, wagent, magent uniquement)
40 octets
TRANSFERRED
C
smallint (dagent, hagent)
4 octets
integer (wagent, magent)
2 octets
PARTIAL_ARCHIVE
I
smallint (hagent uniquement)
2 octets