座席数据库项目

上次更新时间 : Apr 11, 2025 |
前言信息
元数据
关键字：
座席数据库项目说明仅适用于历史项目。历史座席数据库项目适用于以下表格：
  • 时段内座席 (hagent）hagent)
  • 每日座席(dagent）dagent)
  • 每周座席 (wagent）wagent)
  • 每月座席 (magent）magent)
除非另有说明，否则此处列出的所有项目全都包含在这四个数据库表中。
数据库项目
数据类型
列类型
长度
ABNCALLS
C
smallint (hsplit)dagent, hagent)
2 个字节
integer (仅限magent, wagent)
4 个字节
ABNTIME
C
smallint (仅限hagent)
4 个字节
integer (仅限dagent, magent, wagent)
2 个字节
ACCEPTEDINTRS
C
smallint (hsplit)hagent)
2 个字节
integer (仅限dagent, wagent, magent)
4 个字节
ACD（索引）
I
smallint
2 个字节
ACD_RELEASE
C
integer (仅限dagent, wagent, magent 仅限表格）
4 个字节
ACDAUXOUTCALLS
C
smallint (hsplit)dagent, hagent)
2 个字节
integer (仅限wagent, magent)
4 个字节
ACDCALLS
C
smallint (hsplit)dagent, hagent)
2 个字节
integer (仅限wagent, magent)
4 个字节
ACDCALLS_R1
C
integer (仅限dagent, wagent, magent)
4 个字节
smallint (仅限hagent)
2 个字节
ACDCALLS_R2
C
integer (仅限dagent, wagent, magent)
4 个字节
smallint (仅限hagent)
2 个字节
ACDTIME
C
integer (仅限dagent, wagent, magent)
4 个字节
smallint (仅限hagent)
2 个字节
ACWINCALLS
C
smallint (hsplit)dagent, hagent)
2 个字节
integer (仅限wagent, magent)
4 个字节
ACWINTIME
C
integer (仅限dagent, wagent, magent)
4 个字节
smallint (仅限hagent)
2 个字节
ACWOUTADJCALLS
C
smallint (hsplit)dagent, hagent)
2 个字节
integer (仅限wagent, magent)
4 个字节
ACWOUTCALLS
C
smallint (hsplit)dagent, hagent)
2 个字节
integer (仅限wagent, magent)
4 个字节
ACWOUTOFFCALLS
C
smallint (hsplit)dagent, hagent)
2 个字节
integer (仅限wagent, magent)
4 个字节
ACWOUTOFFTIME
C
integer (仅限dagent, magent, wagent)
4 个字节
smallint (仅限hagent)
2 个字节
ACWOUTTIME
C
integer (仅限dagent, magent, wagent)
4 个字节
smallint (仅限hagent)
2 个字节
ACWTIME
C
integer (仅限dagent, magent, wagent)
4 个字节
smallint (仅限hagent)
2 个字节
ANSRINGTIME
C
integer (仅限dagent, magent, wagent)
4 个字节
smallint (仅限hagent)
2 个字节
ASSISTS
C
smallint (hsplit)dagent, hagent)
2 个字节
integer (仅限wagent, magent)
4 个字节
ATTRIB_ID
A
char（20） - 字母数字字符串
20 个字节
AUXINCALLS
C
smallint (hsplit)dagent, hagent)
2 个字节
integer (仅限wagent, magent)
4 个字节
AUXINTIME
C
integer (仅限dagent, magent, wagent)
4 个字节
smallint (仅限hagent)
2 个字节
AUXOUTADJCALLS
C
smallint (hsplit)dagent, hagent)
2 个字节
integer (仅限wagent, magent)
4 个字节
AUXOUTCALLS
C
smallint (hsplit)dagent, hagent)
2 个字节
integer (仅限wagent, magent)
4 个字节
AUXOUTOFFCALLS
C
smallint (hsplit)dagent, hagent)
2 个字节
integer (仅限wagent, magent)
4 个字节
AUXOUTOFFTIME
C
integer (仅限dagent, magent, wagent)
4 个字节
smallint (仅限hagent)
2 个字节
AUXOUTTIME
C
integer (仅限dagent, magent, wagent)
4 个字节
smallint (仅限hagent)
2 个字节
CONFERENCE
C
smallint (hsplit)dagent, hagent)
2 个字节
integer (仅限wagent, magent)
4 个字节
DA_ABNCALLS
C
smallint (hsplit)dagent, hagent)
2 个字节
integer (仅限wagent, magent)
4 个字节
DA_ABNTIME
C
integer (仅限dagent, magent, wagent)
4 个字节
smallint (仅限hagent)
2 个字节
DA_ACDCALLS
C
smallint (hsplit)dagent, hagent)
2 个字节
integer (仅限wagent, magent)
4 个字节
DA_ACDTIME
C
integer (仅限dagent, magent, wagent)
4 个字节
smallint (仅限hagent)
2 个字节
DA_ACWINCALLS
C
smallint (hsplit)dagent, hagent)
2 个字节
integer (仅限wagent, magent)
4 个字节
DA_ACWINTIME
C
integer (仅限dagent, magent, wagent)
4 个字节
smallint (仅限hagent)
2 个字节
DA_ACWOADJCALLS
C
smallint (hsplit)dagent, hagent)
2 个字节
integer (仅限wagent, magent)
4 个字节
DA_ACWOCALLS
C
smallint (hsplit)dagent, hagent)
2 个字节
integer (仅限wagent, magent)
4 个字节
DA_ACWOOFFCALLS
C
smallint (hsplit)dagent, hagent)
2 个字节
integer (仅限wagent, magent)
4 个字节
DA_ACWOOFFTIME
C
integer (仅限dagent, magent, wagent)
4 个字节
smallint (仅限hagent)
2 个字节
DA_ACWOTIME
C
integer (仅限dagent, magent, wagent)
4 个字节
smallint (仅限hagent)
2 个字节
DA_ACWTIME
C
integer (仅限dagent, magent, wagent)
4 个字节
smallint (仅限hagent)
2 个字节
DA_ANSTIME
C
integer (仅限dagent, magent, wagent)
4 个字节
smallint (仅限hagent)
2 个字节
DA_ICRPULLCALLS
C
整数
4 个字节
DA_ICRPULLTIME
C
整数
4 个字节
DA_OTHERCALLS
C
smallint (hsplit)dagent, hagent)
2 个字节
integer (仅限wagent, magent)
4 个字节
DA_OTHERTIME
C
integer (仅限dagent, magent, wagent)
4 个字节
smallint (仅限hagent)
2 个字节
DA_RELEASE
C
整数
4 个字节
EVENT1-EVENT9
C
smallint (hsplit)dagent, hagent)
2 个字节
integer (仅限wagent, magent)
4 个字节
EXTENSION
A
char（16） - ASCII 文本字符串
16 个字节
HOLDABNCALLS
C
smallint (hsplit)dagent, hagent)
2 个字节
integer (仅限wagent, magent)
4 个字节
HOLDACDTIME
C
整数
4 个字节
HOLDCALLS
C
smallint (hsplit)dagent, hagent)
2 个字节
integer (仅限wagent, magent)
4 个字节
HOLDTIME
C
integer (仅限dagent, magent, wagent)
4 个字节
smallint (仅限hagent)
2 个字节
I_ACDAUXINTIME
C
integer (仅限dagent, magent, wagent)
4 个字节
smallint (仅限hagent)
2 个字节
I_ACDAUX_OUTTIME
C
integer (仅限dagent, magent, wagent)
4 个字节
smallint (仅限hagent)
2 个字节
I_ACDOTHERTIME
C
integer (仅限dagent, magent, wagent)
4 个字节
smallint (仅限hagent)
2 个字节
I_ACDTIME
C
integer (仅限dagent, magent, wagent)
4 个字节
smallint (仅限hagent)
2 个字节
I_ACWINTIME
C
integer (仅限dagent, magent, wagent)
4 个字节
smallint (仅限hagent)
2 个字节
I_ACWOUTTIME
C
integer (仅限dagent, magent, wagent)
4 个字节
smallint (仅限hagent)
2 个字节
I_ACWTIME
C
integer (仅限dagent, magent, wagent)
4 个字节
smallint (仅限hagent)
2 个字节
I_AUXINTIME
C
integer (仅限dagent, magent, wagent)
4 个字节
smallint (仅限hagent)
2 个字节
I_AUXOUTTIME
C
integer (仅限dagent, magent, wagent)
4 个字节
smallint (仅限hagent)
2 个字节
I_AUXSTBYTIME
C
integer (仅限dagent, magent, wagent)
4 个字节
smallint (仅限hagent)
2 个字节
I_AUXTIME
C
整数
4 个字节
I_AUXTIME0 - 99
C
整数
4 个字节
I_AUXTIME_R1
C
整数
4 个字节
I_AUXTIME_R2
C
整数
4 个字节
I_AVAILTIME
C
integer (仅限dagent, magent, wagent)
4 个字节
smallint (仅限hagent)
2 个字节
I_DA_ACDTIME
C
integer (仅限dagent, magent, wagent)
4 个字节
smallint (仅限hagent)
2 个字节
I_DA_ACWTIME
C
integer (仅限dagent, magent, wagent)
4 个字节
smallint (仅限hagent)
2 个字节
I_OTHERSTBYTIME
C
integer (仅限dagent, magent, wagent)
4 个字节
smallint (仅限hagent)
2 个字节
I_OTHERSTBYTIME_R1
C
integer (仅限dagent, magent, wagent)
4 个字节
smallint (仅限hagent)
2 个字节
I_OTHERSTBYTIME_R2
C
integer (仅限dagent, magent, wagent)
4 个字节
smallint (仅限hagent)
2 个字节
I_OTHERTIME
C
integer (仅限dagent, magent, wagent)
4 个字节
smallint (仅限hagent)
2 个字节
I_RINGTIME
C
integer (仅限dagent, magent, wagent)
4 个字节
smallint (仅限hagent)
2 个字节
I_STAFFTIME
C
integer (仅限dagent, magent, wagent)
4 个字节
smallint (仅限hagent)
2 个字节
ICRPULLCALLS
C
整数
4 个字节
ICRPULLTIME
C
整数
4 个字节
INCOMPLETE
C
smallint (hsplit)hagent, dagent, wagent)
2 个字节
integer (仅限magent)
4 个字节
INTRDELIVERIES
C
smallint (hsplit)hagent)
2 个字节
integer (仅限dagent, magent, wagent)
4 个字节
INTRNOTIFIES
C
smallint (hsplit)hagent)
2 个字节
integer (仅限dagent, magent, wagent)
4 个字节
INTRVL
A
smallint (仅限hagent ）
2 个字节
LOC_ID
I
smallint
2 个字节
LOGID（索引）
A
char（16） - ASCII 文本字符串
16 个字节
NOANSREDIR
C
smallint (hsplit)dagent, hagent)
2 个字节
integer (仅限wagent, magent)
4 个字节
O_ACDCALLS
C
smallint (hsplit)dagent, hagent)
2 个字节
integer (仅限wagent, magent)
4 个字节
O_ACDTIME
C
integer (仅限dagent, magent, wagent)
4 个字节
smallint (仅限hagent)
2 个字节
O_ACWTIME
C
integer (仅限dagent, magent, wagent)
4 个字节
smallint (仅限hagent)
2 个字节
PHANTOMABNS
C
smallint (hsplit)dagent, hagent)
2 个字节
integer (仅限wagent, magent)
4 个字节
REJECTEDINTRS
C
smallint (hsplit)hagent)
2 个字节
integer (仅限dagent, wagent, magent)
4 个字节
RINGCALLS
C
smallint (hsplit)dagent, hagent)
2 个字节
integer (仅限wagent, magent)
4 个字节
RINGTIME
C
integer (仅限dagent, magent, wagent)
4 个字节
smallint (仅限hagent)
2 个字节
ROIFREDIR
C
整数
4 个字节
ROOFREDIR
C
整数
4 个字节
ROW_DATE（索引）
I
日期 - INFORMIX 日期
4 个字节
RSV_LEVEL（索引）
I
smallint
2 个字节
SPLIT（索引）
I
smallint
2 个字节
STARTTIME
I
smallint (仅限hagent ）
2 个字节
STARTTIME_UTC
I
integer (仅限hagent ）
4 个字节
TENANT
I
整数
4 个字节
TI_AUXTIME
C
integer (仅限dagent, magent, wagent)
4 个字节
smallint (仅限hagent)
2 个字节
TI_AUXTIME0 - 9 或
TI_AUXTIME0 - 99
C
整数
4 个字节
TI_AVAILTIME
C
integer (仅限dagent, magent, wagent)
4 个字节
smallint (仅限hagent)
2 个字节
TI_OTHERTIME
C
integer (仅限dagent, magent, wagent)
4 个字节
smallint (仅限hagent)
2 个字节
TI_STAFFTIME
C
integer (仅限dagent, magent, wagent)
4 个字节
smallint (仅限hagent)
2 个字节
TIMEZONE
A
char（40） - ASCII 文本字符串 （dagent, wagent, magent ）
40 个字节
TRANSFERRED
C
smallint (仅限dagent, hagent)
4 个字节
integer (仅限wagent, magent)
2 个字节
PARTIAL_ARCHIVE
I
smallint (仅限hagent ）
2 个字节