Split/Skill database items

Last Updated : Nov 20, 2024 |
Prolog information
Metadata
Keywords:
The Split/Skill database item descriptions apply to historical items. Historical split/skill database items apply to the following tables:
  • Intrahour Split/Skill (hsplit)
  • Daily Split/Skill (dsplit)
  • Weekly Split/Skill (wsplit)
  • Monthly Split/Skill (msplit)
Unless indicated otherwise, all of the database items listed here are included in all four database tables.
Database item
Data type
Column type
Length
ABNCALLS
C
integer
4 bytes
ABNCALLS1-ABNCALLS10
C
integer
4 bytes
ABNCALLSACC1-ABNCALLSACC10
C
integer (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 (index)
C
integer (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
integer (dsplit, wsplit, msplit)
4 bytes
smallint (hsplit)
2 bytes
ACDCALLS_R1
C
integer
4 bytes
ACDCALLS_R2
C
integer
4 bytes
ACDTIME
C
integer (hsplit, dsplit)
4 bytes
int8 (wsplit, msplit)
8 bytes
ACWINCALLS
C
integer
4 bytes
ACWINTIME
C
integer (dsplit, wsplit, msplit)
4 bytes
smallint (hsplit)
2 bytes
ACWOUTADJCALLS
C
integer
4 bytes
ACWOUTCALLS
C
integer
4 bytes
ACWOUTOFFCALLS
C
integer (dsplit, wsplit, msplit)
4 bytes
smallint (hsplit)
2 bytes
ACWOUTOFFTIME
C
integer (dsplit, wsplit, msplit)
4 bytes
smallint (hsplit)
2 bytes
ACWOUTTIME
C
integer
4 bytes
ACWTIME
C
integer (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
integer (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
integer (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
integer (hsplit, dsplit)
4 bytes
int8 (wsplit, msplit)
8 bytes
I_ACWTIME_R1
C
integer
4 bytes
I_ACWTIME_R2 3
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
integer (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
integer (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
integer (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
integer (hsplit, dsplit)
4 bytes
int8 (wsplit, msplit)
8 bytes
I_TAUXTIME
C
integer
4 bytes
I_TAVAILTIME
C
integer (hsplit, dsplit)
4 bytes
int8 (wsplit, msplit)
8 bytes
I_TOTHERTIME
C
integer (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
integer (dsplit, wsplit, msplit)
4 bytes
smallint (hsplit)
2 bytes
MAXOCWTIME
M
integer
4 bytes
MAXSTAFFED
M
integer (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
integer (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 (index)
I
date - Informix date
4 bytes
RSV_LEVEL
smallint
2 bytes
SERVICELEVEL
A
integer (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 (index)
I
smallint (dsplit, wsplit, msplit)
2 bytes
STARTTIME
I
smallint (hsplit only)
2 bytes
STARTTIME_UTC
I
integer (hsplit only)
4 bytes
SVCLEVELCHG
A
integer (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) - ASCII text (dsplit, wsplit, msplit only)
40 bytes
TOPCALLS
C
integer
4 bytes
TRANSFERRED
C
integer
4 bytes